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

163 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
cestoid10401167(None) 
cestoi84511951cestoi_
cestoids11308281cestoids
cystoid13309211cystoid
bestrid1039972bestrid
cactoid12311032cactoid
ceboid11310652ce_boid
centroid1159312centroid
ceratoid1149922ceratoid
cesti75217422cest_i_
cestode1037962cestode
cestos84718092cesto_s
cissoid1037342cissoid
cystoids14306742cystoids
deltoid938572deltoid
dentoid9310662dentoid
desmoid1137102desmoid
histoid1139822histoid
lentoid8310682lentoid
mastoid10711232mastoid
agatoid948623agatoid
bestead10389123bestead
bested94922763best_ed
bestir8311163best_ir
bestow1149463besto_w
bestowed14156623bestowed
bestows1248863bestows
bestride1138613bestride
bestud9439303best_ud
carotid102014833carotid
castled104311513castled
castoff1547793castoff
castor84418533casto_r
castors94919443castors
cebid104314083ce__bid
ceboids1237653ce_boids
centai84814783centai_
cento76625173cento__
centos85920463cento_s
centred103411683centred
centric11312403centric
centroids1247053centroids
cepheid1545433cepheid
cerotic11415063cerotic
certain92612213certain
cervid1239323ce_rvid
cessed94615613ces_sed
cession939813cession
cesspit1145463cesspit
cesta75419483cest__a
cestas85018543cest_as
cestodes1138203cestodes
cestus84412913cest_us
cheloid13310833cheloid
chested133811683chest_ed
choroid13311803choroid
chytrid1645733chytrid
cirsoid1038123cirsoid
cissoids1145373cissoids
cisted95217523cist_ed
coccoid11299283coccoid
colloid10312883colloid
conoid9818883c_onoid
cormoid12310403cormoid
cosmid11810643cos_mid
costard104113353costard
costed95623123cost_ed
crested103416553crest_ed
cricoid1239253cricoid
crinoid1039943crinoid
ctenoid1078683ctenoid
cuboid1139503c_uboid
cuspid11429213cus_pid
custard10389973custard
custody1334093custody
custom104010273custo_m
customs11348263customs
custos84014313custo_s
cycloid1539283cycloid
cymoid1459473c_ymoid
cystein1246053cystein
cystic132710653cyst_ic
deltoids1045483deltoids
dermoid1138523dermoid
desmid1048363des_mid
desmoids1244973desmoids
despoil1046523despoil
despond1137513despond
destain8412083destain
devoid1189363de_void
discoid11311243discoid
entoil6912493_entoil
essoin638193_essoin
estop74312103_esto_p
estops84011223_estops
estrin6315923_estrin
factoid1338693factoid
festoon1037673festoon
fetid93715983fe_t_id
geoid74215763ge__oid
gessoed935743gessoed
gestic9312773gest_ic
hematoid1449753hematoid
hemoid12313513he_moid
jested144416503jest_ed
keloid11812623ke_loid
keratoid1347273keratoid
lentoids947443lentoids
mastoids1177873mastoids
mattoid1079283mattoid
meloid9616003me_loid
negroid9108903negroid
nested74720073nest_ed
nestled8349913nestled
nestor63713423nesto_r
nestors73614973nestors
neuroid81110313neuroid
nevoid1098803ne_void
oceloid1037973oce_loid
oestrin7312243oestrin
osteoid848203_osteoid
peptid112712373pept_id
percoid12312323percoid
pestled102711453pestled
pesto75723723pesto__
pestos84719083pesto_s
phytoid1678753phytoid
resaid74517083res_aid
reshod103012233resho_d
reshoed112212153reshoed
resid64124093res__id
resinoid946413resinoid
resod64720053res_o_d
resold73915363res_old
respond1039113respond
rested74430783rest_ed
restock1338673restock
restoke116113903restoke
restoked135710533restoked
restore75822983restore
restored96417193restored
retold73013753re_told
sesamoid1144063sesamoid
sistroid947273sistroid
sloid64619713__sloid
staid66722083__staid
stoic7317253__stoic
stolid74213183__stolid
stood65517713__stood
teratoid9411073teratoid
tested74421523test_ed
testis64916713test_is
teston6313303testo_n
testons7313563testons
testoon748373testoon
upstood1044243upstood
vespid1246083ves_pid
vested104217353vest_ed
vetoed10359823ve_toed
viscoid1337023viscoid
xystoi16365133xystoi_
zebroid1936473zebroid
zested164214043zest_ed

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271637.36018210.2
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.82922824.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.