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

104 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
cestoids1130827(None) 
cestoid104011671cestoid_
cystoids14306731cystoids
ceboids1237652ce_boids
centroids1247042centroids
cestode1037962cesto_de
cestodes1138202cestodes
cestoi84511952cestoi__
cestos84718092cesto__s
cissoids1145362cissoids
cystoid13309212cystoid_
deltoids1045482deltoids
desmoids1244972desmoids
lentoids947442lentoids
mastoids1177872mastoids
besteads11307113besteads
bestirs9311133best_irs
bestows1248863besto_ws
bestrid1039973bestrid_
bestride1138613bestride
bestrides1237913bestrides
bestuds10326753best_uds
cactoid12311033cactoid_
carotids11229943carotids
castoffs1644043castoffs
castors94919443casto_rs
cebids11439173ce__bids
ceboid11310653ce_boid_
centones10313663centones
centos85920463cento__s
centroid1159313centroid_
cepheids1644243cepheids
ceratoid1149923ceratoid_
cessions1039853cessions
cesspits1243663cesspits
cestas85018543cest__as
cesti75217423cest_i__
cestus84412913cest__us
cestuses1038083cestuses
cheloids1438033cheloids
choroids1438693choroids
chytrids1744223chytrids
cissoid1037343cissoid_
coccoids12176793coccoids
colloids11310173colloids
conoids10813883c_onoids
cosmids1237633cos_mids
costards113510793costards
cricoids1347183cricoids
crinoids1147363crinoids
cuboids1236723c_uboids
cuspids12427113cus_pids
custards11338393custards
custodes1136653custodes
custodies1245963custodies
custody1334093custo_dy
customs11348263custo_ms
custos84014313custo__s
cycloids1647043cycloids
cysteins1355733cysteins
deltoid938573deltoid_
dentoid9310663dentoid_
dermoids1246163dermoids
desmids1166603des_mids
desmoid1137103desmoid_
despoils1145623despoils
desponds1246243desponds
destains9311813destains
discoids1239873discoids
entoils7810733_entoils
essoins737603_essoins
estops84011223_esto_ps
estrins7315853_estrins
factoids1446243factoids
festoons1136443festoons
geoids8369843ge__oids
histoid1139823histoid_
keloids1288663ke_loids
lentoid8310683lentoid_
mastoid10711233mastoid_
mattoids1196183mattoids
meloids10911453me_loids
negroids10116323negroids
nestors73614973nesto_rs
oestrins8312673oestrins
osteoids945953_osteoids
peptids12239323pept_ids
percoids1339663percoids
pestos84719083pesto__s
resids74219153res__ids
resinoids1044703resinoids
resods74116303res_o_ds
responds1136913responds
restocks1437503restocks
restokes125213043restokes
restores85222993restores
sesamoids1243053sesamoids
sloids73712693__sloids
stoics8311113__stoics
testis64916713test_i_s
testons7313563testo_ns
testoons837323testoons
vespids1334613ves_pids
vestries11314053vestries

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.436409841.7
2DLD Change Limit1461621046.64322002.4
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.12525079.4
 
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.