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

155 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
cestodes113820(None) 
cestode1037961cestode_
custodes1136651custodes
centones10313662centones
cestoids11308272cestoids
cestos84718092cesto__s
cestuses1038082cestuses
custodies1245962custodies
pentodes11310362pentodes
restokes125213042restokes
restores85222992restores
acetones10310033ace_tones
besides104814533bes_ides
besmokes16406363besmokes
bestowed14156613bestowed
bestower13126203bestower
bestowers14135323bestowers
bestows1248863besto_ws
bestrides1237913bestrides
bestrode1147133bestrode_
bestuds10326753bestud_s
betides104915263be_tides
caestuses1144893caestuses
capstones1347373capstones
cascades13128553cascades
caseoses1039293caseoses
castes85631863cast__es
castles94917733cast_les
castoffs1644043castoffs
castors94919443casto_rs
cathodes1439393cathodes
cedes84927323ce___des
cenotes92814543ce_notes
centares102913893centares
centeses1079443centeses
centiles103615813centiles
centimes124012613centimes
centos85920463cento__s
centres93817123cent_res
ceratodus1243223ceratodus
certes84623083cert__es
cesses84221363ces__ses
cestas85018543cest__as
cestoi84511953cesto__i
cestoid104011673cesto_id
cestus84412913cest__us
cetanes9315133ce_tanes
cetes75731103ce_t__es
ciscoes113610733cisco_es
cistuses1038283cistuses
citoles9312553c_itoles
cladodes1245323cladodes
codes86247293c___odes
commodes1539093commodes
copestones1467613copestones
corrodes111310333corrodes
cosmoses1239703cosmoses
costumes1258013costumes
crunodes1144973crunodes
cuspides13306943cuspides
custody1334093custod_y
customer1245383customer
customers1344783customers
customs11348263custo_ms
custos84014313custo__s
cystines1339473cystines
cystoids14306733cystoids
decodes113914983de_codes
destines93619663destines
detoxes1538803de_toxes
distomes11314163distomes
ecotones1039493ecotones
encodes10310643_encodes
epodes94315563_e_podes
erodes74819883_e_rodes
estates74520183_estates
estops84011223_esto_ps
estovers1136453_estovers
estrones8313323_estrones
etudes73811603_e_tudes
eyestones1246323eyestones
felstones1246963felstones
festoons1136433festoons
gemstones1245563gemstones
geodes8412153ge__odes
gessoes838293gesso_es
gestates93213733gestates
gestes75721393gest__es
gestures9310013gestures
gustoes879873gusto_es
heptoses1338373heptoses
histones11312803histones
ketones115014503ke_tones
ketoses114912873ke_toses
keystones1645083keystones
mestees94617753mest_ees
metopes11311363me_topes
miscodes13310423miscodes
nematodes1254733nematodes
nestles73015463nest_les
nestors73614973nesto_rs
oestrones949773oestrones
ostoses71213553_ostoses
pentode1039893pentode_
pentoses10312893pentoses
peptides132610263peptides
peptones12311033peptones
pesades10310903pes_ades
pestholes1448233pestholes
pestles93217693pest_les
pestos84719083pesto__s
pistoles102514723pistoles
postcodes1446153postcodes
prestores114716083prestores
recodes102918633re_codes
rescores105415693rescores
reshoes102316033resho_es
resides84523283res_ides
resods74116303res_od_s
resoles73823653res_oles
respades1139853respades
restages92815773restages
restates83423433restates
restocks1437503restocks
restoke116113903restoke_
restoked135710533restoked
restore75822973restore_
restored96417193restored
restorer84813723restorer
restorers95110113restorers
restudies10156033restudies
restyles1139193restyles
sestines82717243sestines
spodes94817433__spodes
stades74626243__stades
stodges9309083__stodges
stokes104821793__stokes
stoles63927673__stoles
stones65130033__stones
stopes84525893__stopes
stores65533663__stores
stoves93818923__stoves
systoles1146483systoles
testates83615453testates
testees74215913test_ees
testes65125823test__es
testons7313553testo_ns
testoons837303testoons
testudos943053testudos
tetrodes939093tetrodes
vestees103513173vest_ees
vestiges1238243vestiges
vestries11314053vestries
vestures11311043vestures
vetoes92914083ve_to_es

Search took 10 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.1701051123.5
2DLD Change Limit1461621558.89016441.2
3Display Results1551550.0632460.3
 (SQL Overall)1786911559.12319586.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.