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

92 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
cycloids164704(None) 
cycloid1539281cycloid_
cheloids1438032cheloids
coccoids12176792coccoids
colloids11310172colloids
cyclins1438302cycl_ins
cycloidal1744322cycloidal
cyclones1537482cyclones
cyclopes1746262cyclopes
cyclops1635382cyclo_ps
cyclos1338072cyclo__s
cycloses1538182cycloses
cyclosis1547472cyclosis
cystoids14306732cystoids
hyaloids1545992hyaloids
acyclovirs2051483acyclovirs
acyloins1345903acy_loins
amyloids1446003amyloids
beclouds1345373beclouds
cactoid12311033cactoid_
cancroids1444533cancroids
carloads1138393carloads
ceboids1237653c_eboids
cestoids11308273cestoids
chalcids1635893chalcids
cheloid13310833cheloid_
chlorids14299673c_hlorids
choroids1438693choroids
cichlids1643663cichlids
cissoids1145363cissoids
clods85320863__clo_ds
clouds94612353__clouds
coccids11277213coc_cids
coccoid11299283coccoid_
colloid10312883colloid_
conchoids1766273conchoids
conoids10813883c_onoids
couloirs1045993couloirs
cricoids1347183cricoids
crinoids1147363crinoids
cuboids1236723c_uboids
cuckolds1743003cuckolds
cyanids13297933cy_anids
cycadeoids1951453cycadeoids
cycads14476213cyc__ads
cycasins1545283cycasins
cyclases1537133cyclases
cycled1436543cycl_ed_
cycleries1647033cycleries
cyclers1435873cycl_ers
cycles1339303cycl__es
cyclic1238033cycl_i_c
cyclin1339273cycl_i_n
cycling1537213cycl_ing
cyclings1635373cyclings
cyclist1438853cycl_ist
cyclists1545713cyclists
cyclize2345403cycl_ize
cyclizes2445523cyclizes
cyclo1237703cyclo___
cyclonal1544603cyclonal
cyclone1437243cyclo_ne
cyclonic1446973cyclonic
cyclonite1645453cyclonite
cyclonites1744913cyclonites
cymlins1436693cyml_ins
cymoid1459473cy_moid_
cystoid13309213cystoid_
diploids1247843diploids
epicycloids2161863epicycloids
euploids1157243euploids
eyelids1135943eyel_ids
factoids1446243factoids
fucoids1335663fuc_oids
haloids113012553_haloids
haploids1437363haploids
hyaloid1439073hyaloid_
hydroids1647763hydroids
hyoids1377673hy__oids
keloids1288663_keloids
loids66220703___loids
meloids10911453_meloids
mucoids1237423muc_oids
myceloid1644853myceloid_
myeloid13108123myeloid_
nucleoids1244923nucleoids
phylloids1844523phylloids
sloids73712693__sloids
tabloids1146163tabloids
typhoids1745493typhoids
unclouds1144883unclouds
xyloid1738193xy_loid_

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 Filter1786911461620.420425454.8
2DLD Change Limit146162926.89321204.4
3Display Results92920.0303066.7
 (SQL Overall)178691927.34324334.9
 
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.