Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “collocated” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

50 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
collocated154616(None) 
collocate1348661collocate_
collocates1448121collocates
colocated1439611co_located
allocated1248092_allocated
collated113615062coll__ated
collected1447962collec_ted
colligated1446272colligated
collimated1556082collimated
colocate12313432co_locate_
colocates13312852co_locates
allocate10411023_allocate_
allocates11410473_allocates
coelomate1398083coelomate_
coelomates1497553coelomates
cohobated1744883co_hobated
collaborated1772813collaborated
collaged12279963coll__aged
collared113211143coll__ared
collate92919683coll__ate_
collates103019133coll__ates
colleted113011653coll__eted
colligate1248293colligate_
colligates1347713colligates
collimate1348163collimate_
collimates1447973collimates
collocating1645883collocating
collocation1547163collocation
collogued1344073collo_gued
colorcasted1652353colorcasted
complicated2046093complicated
concocted1346763concoc_ted
conglobated1753003conglobated
consociated1645213consociated
coplotted1444793coplo_tted
coronated123313323co_ronated
corotated122810053co_rotated
coruscated1544463coruscated
dislocated1497523dislocated
holloaed12157393hollo_a_ed
located103114183___located
mislocated15196253mislocated
pollenated1345013pollenated
pollinated1345823pollinated
prelocated1597183prelocated
reallocated1443773reallocated
relocated12710813_relocated
unallocated14113323unallocated
unlocated1238383_unlocated
vellicated1644803vellicated

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911406030.1531167915.0
2DLD Change Limit140603506.48621677.9
3Display Results50500.0301666.7
 (SQL Overall)178691506.66926794.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.