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 “cycloid” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
cycloid153928(None) 
cycloids1647041cycloids
cactoid12311032cactoid
cheloid13310832cheloid
coccoid11299282coccoid
colloid10312882colloid
cycled1436542cycl_ed
cyclic1238032cycl_ic
cyclin1339272cycl_in
cyclo1237702cyclo__
cycloidal1744322cycloidal
cyclone1437242cyclone
cyclonic1446972cyclonic
cyclops1635382cyclops
cyclos1338072cyclo_s
cyclosis1547472cyclosis
cymoid1459472cy_moid
cystoid13309212cystoid
hyaloid1439072hyaloid
myceloid1644852myceloid
myeloid13108122myeloid
xyloid1738192xy_loid
acyclic1345573acycl_ic
acyclovir1951603acyclovir
acyloin1247463acy_loin
amyloid1348543amyloid
becloud1246293becloud
cancroid1346523cancroid
carload1039783carload
ceboid11310653c_eboid
cestoid104011673cestoid
chalcid1537883chalcid
cheloids1438033cheloids
chlorid133211843c_hlorid
choroid13311803choroid
cichlid1545313cichlid
cirsoid1038123cirsoid
cissoid1037343cissoid
clod76124613__clo_d
cloud86716423__cloud
coccid102910743coc_cid
coccoids12176793coccoids
colloids11310173colloids
conchoid1688043conchoid
conoid9818883c_onoid
cormoid12310403cormoid
cotyloid1445493cotyloid
couloir936153couloir
cricoid1239243cricoid
crinoid1039943crinoid
ctenoid1078683ctenoid
cuboid1139503c_uboid
cuckold1643723cuckold
cyanid123912043cy_anid
cycad13507273cyc__ad
cycadeoid1851843cycadeoid
cycasin1445903cycasin
cyclase1436613cyclase
cycle1239523cycl__e
cycler1335913cycl_er
cyclers1435873cyclers
cyclery1763493cyclery
cycles1339303cycl_es
cycling1537213cycling
cyclins1438303cyclins
cyclist1438853cyclist
cyclize2345403cyclize
cyclized2544943cyclized
cyclonal1544603cyclonal
cyclones1537483cyclones
cyclonite1645453cyclonite
cyclopes1746263cyclopes
cycloses1538183cycloses
cylix17448623cy_l_ix
cymlin1337313cyml_in
cystoids14306733cystoids
diploid11310293diploid
epicycloid2052413epicycloid
euploid1038963euploid
eyelid1038443eyel_id
factoid1338693factoid
fucoid1237893fuc_oid
haloid104317763_haloid
haploid1339833haploid
hyaloids1545993hyaloids
hydroid1539713hydroid
hyenoid1448613hyenoid
hyoid12612443hy__oid
hypnoid1647883hypnoid
keloid11812623_keloid
loid55531493___loid
meloid9616003_meloid
mucoid1139783muc_oid
myoid11512993my__oid
myxoid1936883my_xoid
nucleoid1145913nucleoid
oceloid1037973oceloid
phylloid1746193phylloid
pygmoid1644533pygmoid
pyoid11513763py__oid
sialoid8310963sialoid
sloid64619713__sloid
styloid1137553styloid
tabloid1048263tabloid
typhoid1648133typhoid
uncloud1046433uncloud
yclad11246383_ycl_ad
zygoid2045943zy_goid

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271085.76323256.5
3Display Results1081080.0462347.8
 (SQL Overall)1786911086.21528751.6
 
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.