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

254 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
teredos83918(None) 
reredos838631reredos
teredo7310781teredo_
credos94612852_credos
heredes11313132heredes
redos65126762__redos
stereos74314972stere_os
teledus835092teledus
toledos8388862toledos
toreros7311342toreros
torpedos1143932torpedos
tuxedos1543292tuxedos
uredos73910622_uredos
aerugos834923aerugos
albedos1075253albedos
berets85822523bere_ts
boredom1236943boredom
boredoms1346043boredoms
bredes94818473_bredes
breeds94914883breed_s
cereals9313173cereals
cered85227443cered__
ceres75540013cere__s
cereus85215523cere_us
ceros74726073cer__os
comedos12329073comedos
credo84815573_credo_
creds85418773_cred_s
creeds94714773creed_s
deeds75423763de_ed_s
derides93420853derides
dorados938203dorados
eidos65817753_e_idos
erects84116183_erects
erenow937373_erenow
erodes74819883_erodes
eros45238453_er__os
erugos7347343_erugos
exodos1435943_exodos
feeds94921143fe_ed_s
feres86038183fere__s
firedog1244473firedog
firedogs1344793firedogs
foredo10510823foredo_
foredoes12310803foredoes
freedom1345863freedom
freedoms1445433freedoms
gerents82612923gerents
greeds84314283greed_s
gregos847533_gregos
haeredes1246333haeredes
heeds95420423he_ed_s
herders113914123herders
herds96424683her_d_s
hereof123212373here_of
hereon93914363here_on
heres86245903here__s
hereto9313693hereto_
heros84930863her__os
heteros10312683heteros
jereeds15326393jereeds
jerids142810943jerid_s
kendos114510663ke_ndos
meeds84920273me_ed_s
menudos1034643menudos
merdes94518603mer_des
meres75143573mere__s
merinos9311983merinos
needs65719633ne_ed_s
nerds65719253ner_d_s
nereides938503nereides
nereids838743nereids
nereis6315343nere_is
ordos65216203_or_dos
parados103816053parados
pareos87023773pare_os
parodos103011753parodos
perdus93711273per_dus
pereion9312053pereion
pereions10310853pereions
pereon83517453pere_on
pereons92815003pereons
peres76246643pere__s
peridot10514243peridot
peridots1138323peridots
periods10312243periods
pernods1038483pernods
recedes102816063recedes
redds74617833__redds
redes65139133__redes
redo56029363__redo_
redoes74623773__redoes
redon65424883__redon
redons75222183__redons
redox134714233__redox
reds56042863__red_s
reeds65430903re_ed_s
repos74725793__repos
rereads81512293rereads
reredoses1045773reredoses
rerents73319423rerents
resedas839123resedas
reweds104412303rewed_s
rezeros1647453rezeros
secedes103711983secedes
seeds64330063se_ed_s
sered65737293sered__
sereins73716123sereins
serenes73222903serenes
seres55448893sere__s
serfdom1344213serfdom
serfdoms1443763serfdoms
servos93812723ser_vos
shreds105613053shred_s
speedos10298263speedos
steeds73814883ste_ed_s
stereo65317913stere_o_
steres63929533stere__s
tardo65321103tar_do_
tared69340053tared__
tares57456563tare__s
taros55640823tar__os
teared75722153teared__
tearers75218233teare_rs
technos1236183technos
tedders94010233tedders
teds54932573t__ed_s
teed55439263te_ed__
teels55726373te_e_ls
teems76019783te_e_ms
teens56227483te_e_ns
tees45353583te_e__s
teiids736693teiid_s
teinds738263teind_s
telcos8710683te_lcos
telecom1146813telecom
telecoms1246473telecoms
teledu737303teled_u
telegas837443telegas
teleost7410523tele_ost
teles54536003tele__s
teleses7313123teleses
telesis7310793telesis
telexes1438353telexes
telos55424523t__elos
tempos103812293te_mpos
tenders83719723tenders
tendon7312033te_ndon
tendons8311473te_ndons
tends65425583te_nd_s
tendus75111183te_ndus
tenets65518953tene_ts
tenrecs936033tenre_cs
tenutos736623tenutos
tepees84215243tepe_es
terais64023513ter_ais
terbias9310743terbias
tercels94110363tercels
terces83921413ter_ces
tercets93512443tercets
terebic1137983terebic
teredines1049453teredines
terefah1344113terefah
terete6319333tere_te
termed94816703termed__
termers95414503termers
termor84412513ter_mor
termors94712773termors
terms75523473ter__ms
ternes65422903ter_nes
ternion739493ternion
ternions838813ternions
terns55226873ter__ns
terpenes102111573terpenes
terras63516973ter_ras
terreens8246533terreens
terrenes82212603terrenes
terrets72913583terrets
terries73425633terries
territs72714503territs
terror63811733ter_ror
terrors73112213terrors
testudos943053testudos
tetrads82910193tetrad_s
tetrodes939093tetrodes
tewed94718533tewed__
therefor1494453therefor
thereof13168063there_of
thereon10199263there_on
theres96525473there__s
thereto1038993thereto_
thermos124610753ther_mos
threads11419953threads
threaps12488643threaps
threats104311673threats
threeps12687043threeps
threes97117323thre_es
tiered73613973tiered__
tirades8311723tirades
tired65228903tired__
tireder837703tireder
tiredest938403tiredest
tiredly1136803tiredly
tires55437493tire__s
tiros54524893tir__os
toledo7419993toledo_
tondos75115923t_ondos
toreador945003toreador
toreadors1045153toreadors
torero6313203torero_
tores55352673tore__s
tornados945373tornados
toros54336193tor__os
torpedo1035053torpedo_
torpedoes1243943torpedoes
torsos64815733tor_sos
tournedos1042533tournedos
trades75724503t_rades
treads74817923t_reads
treats64821693t_reats
treed65626733treed__
treens65317873t_reens
trees55835763t_re_es
treetop945523treetop
treetops1045463treetops
treks96016853t_re_ks
tremor84210403t_remor
tremors93711233t_remors
trends75513543t_rends
tres46542903t_re__s
tress55423163t_re_ss
trets55928023t_re_ts
trews86118893t_re_ws
treys85018213t_re_ys
trigos74214173t_rigos
trios55528093t_r_ios
tripos84014923t_ripos
tupelos936113tupelos
turacos938643turacos
turbos8910783tur_bos
turds65021693tur_d_s
tureens7289873tureens
tuxedo1433133tuxedo_
tuxedoes1642753tuxedoes
tweeds10498433tweed_s
tyred95816433tyred__
tyres84725233tyre__s
tyros85118593tyr__os
uredo65112993_uredo_
versos93812803ver_sos
vireos94212453vire_os
weeds95222213we_ed_s
weirdos11355123weirdos
zeros144918113zer__os

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 Limit1340272547.45317983.0
3Display Results2542540.0803175.0
 (SQL Overall)1786912547.93922508.0
 
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.