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 “coelomate” 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.

60 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
coelomate139810(None) 
acoelomate1454341acoelomate
coelomata1385321coelomata
coelomates1497561coelomates
acoelomates1554112acoelomates
cellmate1237862c_ellmate
celomata1296622c_elomata
coelome1139682coelom__e
collimate1348162collimate
collocate1348662collocate
colocate12313432co_locate
celibate1259313c_elibate
cellmates1347513c_ellmates
checkmate2243533checkmate
chelate122914893chel__ate
chlorate133112693c_hlorate
chromate15312783c_hromate
climate11312833c__limate
cocomat13413623co_comat_
cocomats1449403co_comats
coelom10310423coelom___
coelomes1239293coelom_es
coelomic1445713coelom_ic
coeloms1139063coelom__s
coelostat1145673coelostat
coelostats1253583coelostats
coenobite1344523coenobite
coenocyte1644333coenocyte
coequate1946153coe_quate
cohobate1547013co_hobate
coinmate1239063co_inmate
collate92919683co_l_late
colligate1248293colligate
collimated1556083collimated
collimates1447973collimates
collocated1546163collocated
collocates1448123collocates
colocated1439613co_located
colocates13312853co_locates
comate104124843c___omate
conglobate1563653conglobate
copemate1439993co_pemate
corelate10516013corel__ate
corollate1148123corollate
coronate103018213co_ronate
corotate102813933co_rotate
corporate13410903corporate
coulometer1445443coulometer
cremate113816183cre__mate
crewmate15405623cre_wmate
cyclamate1843793cyclamate
diplomate1476343diplomate
dolomite1148123do_lomite
helpmate1545603_helpmate
myelomata1653343myelomata
ocellate1037863ocel_late
ostomate1049573_ostomate
prelocate13109513prelocate
relocate10713533_relocate
soulmate1047183soul_mate

Search took 8 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 Filter1786911486410.236757165.3
2DLD Change Limit148641607.29620372.9
3Display Results60600.0302000.0
 (SQL Overall)178691607.56223630.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.