Algorithm to match short text strings (equivalent product names from disparate sources)

£20-250 GBP

进行中

已发布

将近 8 年前

£20-250 GBP

货到付款

We have an existing MS SQL database which is populated with products retrieved from various sources (portals). The various portals usually have slightly different names for the products. E.G Portal 1: PortalProduct 1: CocaCola PortalProduct 2: Manchester United PortalProduct 3: Maplin Electronics Portal 2: PortalProduct 1: Coca-Cola PortalProduct 2: Man Utd PortalProduct 3: Maplin Elec Ltd. - We need to correlate these PortalProducts to a central list of Products. - One Product can have 1-to-many PortalProducts - The database is populated with around 10,000 PortalProducts - The database is not populated with any Products. Products need to be added for each new PortalProduct that doesn't match an existing Product. This must be implemented as a C# console application so that a) we can see the results when the correlate is run and b) so that we can ultimately run it on a task-schedule. The developer must develop a text matching algorithm to correlate PortalProduct names with Product names (and create a product where there is no match). The emphasis is on the accuracy of the text matching algorithm. Speed is less important than [login to view URL] developer should have a mathematical mind and preferably has experience in developing mathematical text matching algorithms. Examples of mathematical text matching algorithms that could be used (and potentially refined and combined) to meet our requirements are: String metric Locality-sensitive hashing Needleman–Wunsch algorithm Smith–Waterman algorithm Levenshtein distance Concept Search Approximate matching with addition of regular expressions ability Regular expressions for non-fuzzy (exact) matching Metaphone Soundex Agrep Plagiarism detection [login to view URL] Ideally the developer will already understand and have used some of these before and able to pick the best algorithm(s) for this application.

Algorithm

C# Programming

Mathematics

项目 ID: 10964138

关于此项目

14提案

远程项目

活跃8 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

14威客以平均价£174 GBP来参与此工作竞价

@abhijitbuet

easy task for me :)

£133 GBP 在1天之内

4.9

(146条评论)

6.3

@sflogics

Hi, We are small team of 4 developers with 5+ years of .Net experience and have happy old clients. One from UK from about last 4 years in Bedford. We never had excuses; even not asked to clients to pay extra money. We have alternates to everything like we have 3 power sources, 3 internet connections, spare ready to go computers etc. We care about clients time. I'm 100% you will not disappointed working with us. We can start work from today and will update you daily progress report. This is our routine. Thank you.

£200 GBP 在3天之内

5.0

(50条评论)

6.2

@solutionEngrn

Hi there, You have a Challenge, We Create the Solution Solution Engineering is a Team of quality and solution oriented engineering professionals across various engineering disciplines that have tackled challenges like yours and are ever ready to Provide Solution to your Challenge. We are experienced, highly motivated and dedicated engineers that are ready to work on your challenges and problems, and provide adequate and quality solutions to it. We deliver quality results, on time and under budget. Our highly skilled and well motivated workforce has between 2 to 24 years working experience across various fields of engineering which include: Mechanical Engineering, Electrical Engineering, Telecommunication Engineering, Civil Engineering, Industrial Engineering, Engineering Project Management, Chemical Engineering, Structural Engineering, Aeronautics, Mechatronics, Agricultural Engineering, Manufacturing Technology, Robotics, Bio-Resources Engineering, Renewable Energy systems We also help our clients with engineering related services like: Design of Product, Industrial Design, PowerPoint Presentation, Manufacturer Sourcing, Supplier Sourcing, Product Sourcing and Procurements of goods on behalf of our Clients, Engineering Project Report, Academic Report Writing, MatLab works, SolidWorks, AutoCad, Plant 3D Designs, CNC Milling, CNC Lathe Programming, MS Project WBS, Maintenance Scheduling, Material Procurements, General Engineering, Programming and Coding, Network Engineer

£244 GBP 在4天之内

5.0

(2条评论)

5.3

@SharjeelSohail

hi. im a software development engineer with excellent algorithm design skills. i can do this work for you

£100 GBP 在5天之内

4.9

(60条评论)

5.2

@AbanoubLabib92

I'm C# developer. I worked in Microsoft in AppFactory program for developing Windows 8 and Windows Phone Apps. I got here many Desktop and WPF projects. You can check my profile and if you accepted, just let me know to discuss. Thanks

£150 GBP 在15天之内

5.0

(11条评论)

4.7

@Alethor

Hi! I would like to help you with this project. I have some questions, so, if you are interested, please let's talk BEFORE closing anything. One everything is set and understood, then we will be able to work together perfectly. Thanks

£150 GBP 在3天之内

5.0

(20条评论)

3.9

@pakaimsolutions

Hello, I hope you doing very well! I have gone through the description and would like to provide a quality solution using my 5+ years of professional experience in required skills. (.NET/ASP.NET - MVC, EF, SQL, C#). Awaiting for your positive response so we can have final talk and start project immediately :)

£122 GBP 在3天之内

5.0

(11条评论)

4.0

@joy151280

Hi! Thanks for posting this requirement. I am experts with design and development works. I have developed several websites in ASP.net vb. I have done research in .net I have also made several research tool in vb.net. I can assure you quality works done. I always ensure to make this mutual understanding to work together. Looking forward to have a great time working with you for a long term business relations. Hope to hear from you soon!

£177 GBP 在3天之内

4.7

(2条评论)

3.1

@aptriangle

First, when using an algorithm, instead of a list that contains phrase pairs considered equivalent, there's no way to be completely certain that a match is correct. Any match would have a confidence level. Your first example could be matched using at least three of the methods you mentioned. If done using regular expression searches for missing or changed characters, the confidence level would be based on how many characters were changed. If done using methods that look for similar sections of text, the confidence level would be based on having two matching sections of four letters each. Finally, a phonetic analysis would give a high confidence match. The second example makes things more difficult. Each of the two words in "Man Utd" is only obvious if you consider both words and you recognize the pattern. Many product names may include the word "Man" and there are 155 common words that start with u and contain the letters t and d in that order. The third could be matched by having a list of low-importance words, words that are very common. By eliminating the low importance words, the word "Maplin" becomes the only word being considered and a match is made Realistically, unless you want to invest in a Deep Blue level artificial intelligence, the best you can do is create a program that will automatically match names that are very similar and propose matches that may be the same, storing your answers to build up a dictionary of matches that it will automatically process later

£150 GBP 在5天之内

5.0

(2条评论)

2.0

@sammy2889

Our core competency lies in complete end-end development cum management of a new website development project, and we are seeking opportunities to build Websites/Applications from the ground up for you or your business. Mission- To satisfy our customers and create long lasting business relationships.

£200 GBP 在5天之内

0.0

(0条评论)

0.0

@fifthjourney

I have used Copyleaks and Fuzzystring in a plagiarism checking software for library for a college. Im sure it will be more than enough for this purpose.

£135 GBP 在5天之内

0.0

(0条评论)

0.0

@Mazookr

I wrote something similar for the BBC and MACAT.com. Probably do it in less than 5 days, but good to have some leeway, I have used those exact algos and much more such as ML(wont be needed) I work as a Tech lead and principal developer for 4 large UK blue chip organisations heading teams of more than 50 per company. So yes if you want this with zero hassle, highest quality give us a shout! Send details, will do it for nothing and if you like the solution just pass the goodies over. Good luck!

£277 GBP 在5天之内