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

187 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
cestode103796(None) 
cestodes1138201cestodes
bestrode1147142bestrode
cestoi84511952cesto_i
cestoid104011672cestoid
cestoids11308272cestoids
cestos84718092cesto_s
custodes1136652custodes
custody1334092custody
pentode1039892pentode
restoke116113902restoke
restore75822982restore
acetone9310793ace_tone
acetose938843ace_tose
beside95114613bes_ide
besmoke15416623besmoke
bespoke15468113bespoke
bested94922763bested_
bestow1149463besto_w
bestowed14156623bestowed
bestower13126213bestower
bestows1248863bestows
bestride1138613bestride
bestud9439303bestud_
bestuds10326753bestuds
betide95115973be_tide
capstone1237653capstone
cascade12118603cascade
caseose939163caseose
caste75932363cast__e
castle84918963cast_le
castled104311513castled
castoff1547793castoff
castor84418533casto_r
castors94919443castors
cathode1338993cathode
cede74928773ce___de
cenote83715843ce_note
centare93113703centare
centile94217183centile
centime114513033centime
cento76625173cento__
centones10313663centones
centos85920463cento_s
centre84316643cent_re
centred103411683centred
cespitose1342063cespitose
cessed94615613cessed_
cesta75419483cest__a
cestas85018543cest_as
cesti75217423cest__i
cestus84412913cest_us
cestuses1038083cestuses
cesurae937703cesurae
cetane8315283ce_tane
cete64934783ce_t__e
chested133811673chested_
cisted95217523cisted_
citole8311503c_itole
cladode1134613cladode
code77347733c___ode
commode1438123commode
copestone1397453copestone
corrode101310573corrode
costae85319683cost_ae
costate94019273costate
costed95623113costed_
costive12312843costive
costume1157853costume
crested103416533crested_
crunode1034713crunode
crustose1045503crustose
custodies1245963custodies
custom104010273custo_m
customer1245383customer
customs11348263customs
custos84014313custo_s
cystine1239333cystine
cystoid13309213cystoid
cystoids14306733cystoids
decode104414743de_code
demode104013463de_mode
destine83719953destine
distome10313233distome
ecotone938583ecotone
encode9310443_encode
epode85114093_e_pode
erode64520993_e_rode
estate64719763_estate
estop74312103_esto_p
estops84011223_estops
estrone7413953_estrone
etude63612303_e_tude
eyestone1146533eyestone
felstone1146863felstone
festive1339773festive
festoon1037673festoon
gemstone1145843gemstone
geode7412593ge__ode
gessoed935743gessoed
gestate83614073gestate
geste65920693gest__e
gesture839243gesture
heptose1237493heptose
histone10312843histone
jested144416503jested_
ketone105014533ke_tone
ketose105711813ke_tose
keystone1545333keystone
mestee84523883mest_ee
metope10611123me_tope
miscode12310413miscode
nematode1155163nematode
nested74720063nested_
nestle63013953nest_le
nestled8349913nestled
nestor63713423nesto_r
nestors73614973nestors
oestrone849973oestrone
pentodes11310363pentodes
pentose9311593pentose
peptide122910683peptide
peptone11310763peptone
pesade9311103pes_ade
pesthole1347553pesthole
pestle83215843pest_le
pestled102711453pestled
pesto75723723pesto__
pestos84719083pesto_s
pistole92414313pistole
postcode1346323postcode
prestore104217353prestore
recode93618713re_code
rescore95616203rescore
reshod103012233reshod_
reshoe92816483resho_e
reshoed112212153reshoed
reshone102414163reshone
reside74224933res_ide
resod64720053res_od_
resods74116303res_ods
resole64624183res_ole
respade1039573respade
respoke134311283respoke
restage83316193restage
restate73824883restate
rested74430783rested_
restive10315933restive
restock1338673restock
restoked135710533restoked
restokes125213043restokes
restored96417193restored
restorer84813723restorer
restores85222993restores
restrove1138963restrove
restudy1144763restudy
restyle1038763restyle
retore67630773re_tore
sestine73017923sestine
setose65114773se_tose
spode84617703__spode
stade64825303__stade
stoae55024263__stoae
stodge8369043__stodge
stoke94922513__stoke
stole54928813__stole
stone55431183__stone
stope74727243__stope
store56333813__store
stove85220253__stove
strode75215973__strode
systole1035763systole
testae64216253test_ae
testate73916233testate
tested74421523tested_
testee64323303test_ee
teston6313303testo_n
testons7313563testons
testoon748373testoon
testudo843363testudo
tetrode839343tetrode
vested104217353vested_
vestee94319153vest_ee
vestige1137433vestige
vesture10310373vesture
vetoed10359823ve_toed
zested164214043zested_

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.703254183.5
2DLD Change Limit1340271877.15618729.3
3Display Results1871870.0632968.3
 (SQL Overall)1786911877.92222556.3
 
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.