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

499 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
teredo731078(None) 
teredos839171teredos
cered85227442cered_
credo84815562_credo
foredo10510822foredo
hereto9313692hereto
redo56029362__redo
reredos838632reredos
sered65737292sered_
stereo65317912stere_o
tardo65321102tar_do
tared69340052tared_
teared75722152teared_
teed55439262te_ed_
teledu737302teledu
terete6319332terete
termed94816702termed_
tewed94718532tewed_
thereto1038992thereto
tiered73613972tiered_
tired65228902tired_
toledo7419992toledo
torero6313202torero
torpedo1035052torpedo
treed65626732treed_
tuxedo1433132tuxedo
tyred95816432tyred_
uredo65112992_uredo
acred87126353acred_
aeried74221863aeried_
aero45435343aer__o
aerugo735803aerugo
aired66032923aired_
albedo956123albedo
alfredo1142483alfredo
altered83215733altered_
bared85144483bared_
beedi8711663be_edi
bereft114317303bereft
beret74946363bere_t
berets85822523berets
bermed115217723bermed_
bored85034303bored_
boredom1236933boredom
bred75130973_bred_
brede85520503_brede
breed85526693breed_
breeds94914883breeds
cared86050093cared_
catered103117763catered_
ceded96118553ceded_
cere66741473cere__
cereal8315833cereal
ceres75540013cere_s
cereus85215523cereus
cero66329453cer__o
comedo11359603comedo
cored85044223cored_
cred76530883_cred_
credos94612843_credos
creds85418773_creds
creed85727393creed_
creeds94714773creeds
cured85932133cured_
dared75935013dared_
deed65340903de_ed_
deeds75423763de_eds
deedy104315893de_edy
deked115718533deked_
deled75326543deled_
dere56845903dere__
deride84420033deride
dewed105020303dewed_
dorado838813dorado
dreed75222843dreed_
dured75025403dured_
eared65139503eared_
eddo63411803_e_ddo
eked96718023_eked_
entered82718883entered_
ere36352773_ere__
erect74129333_erect
erenow937373_erenow
ergo56420153_er_go
erode64520993_erode
erred65915673erred_
erugo6369853_erugo
exed125420593_exed_
eyed86623233_eyed_
fared95842343fared_
feared106320433feared_
feed84538903fe_ed_
feeds94921143fe_eds
fere76342233fere__
feres86038183fere_s
feted94420933feted_
feued94715663feued_
fired94829743fired_
firedog1244473firedog
fordo97218653for_do
forego1038903forego
freed95223543freed_
freedom1345853freedom
geared85317743geared_
geed65435503ge_ed_
gerent73223093gerent
gored75227083gored_
greed75125693greed_
greeds84314283greeds
greedy11518843greedy
grego7310523_grego
gyred105114093gyred_
hared95742183hared_
heed86437603he_ed_
heeds95420423he_eds
heired103813043heired_
herbed123513453herbed_
herd84933063her_d_
herded114215643herded
herder104516463herder
herds96424683her_ds
here76447103here__
hereat93527413hereat
hereby14468333hereby
heredes11313133heredes
herein93717793herein
hereof123212373hereof
hereon93914363hereon
heres86245903here_s
heresy125011233heresy
hero74635783her__o
hetero9312633hetero
hewed125619433hewed_
hexed165615763hexed_
hired95226263hired_
ired55131873_ired_
itemed936603itemed_
jeed125428503je_ed_
jeered143912793jeered_
jereed144012063jereed
jereeds15326383jereeds
jerid132316423jerid_
jerids142810943jerids
jerked18479593jerked_
jewed165114833jewed_
kendo105113223ke_ndo
kerbed13339693kerbed_
kerfed14358223kerfed_
kerned114112923kerned_
keyed1369383keyed_
leered73816223leered_
lured65427493lured_
meed74934703me_ed_
meeds84920273me_eds
menudo945793menudo
merde84320123mer_de
merdes94518603merdes
mere67244443mere__
merely111312583merely
merer75126233mere_r
meres75143573mere_s
merest84725113merest
merged104214943merged_
merino8315093merino
meted85424433meted_
metered103514013metered_
metred95315143metred_
mewed115218013mewed_
mired85729223mired_
mitered103213233mitered_
mured85726703mured_
neared75119803neared_
need54934153ne_ed_
needs65719633ne_eds
needy94614693ne_edy
nerd56624943ner_d_
nerds65719253ner_ds
nerdy95014703ner_dy
nereid7312923nereid
nereids838743nereids
nereis6315343nereis
nerved104111683nerved_
oared65030653oared_
ordo54622353_or_do
overdo10128363over_do
overed102216623overed_
pared86946763pared_
pareo74632603pare_o
peed76239183pe_ed_
peered93819483peered_
perdu84216273per_du
perdy115417323per_dy
pere66450263pere__
perea75026443pere_a
pereia85217983pereia
pereion9312043pereion
pereon83517453pereon
peres76246643pere_s
peridot10514243peridot
period9314983period
perked134617683perked_
permed115217343permed_
pernio8513143pernio
pernod9310453pernod
petered103314963petered_
pored85234513pored_
preed85128113preed_
rared65738323rared_
reared75930013reared_
rebred95816353rebred_
recede95515533recede
red46755803__red_
redd66323173__redd
rede55037663__rede
reded74829113reded_
redon65424883__redon
redos65126763__redos
redox134714233__redox
reds56042863__reds
reed55549623re_ed_
reeds65430903re_eds
reedy910020283re_edy
refed93921923refed_
remedy1237863remedy
repo66027543__repo
reread71715433reread
rereads81512293rereads
rerent63832453rerent
reseda739703reseda
rewed95425453rewed_
reweds104412303reweds
rezero1578873rezero
seared75232843seared_
secede93311993secede
seed55549483se_ed_
seeds64330063se_eds
seedy94821533se_edy
sere46153473sere__
serein63318463serein
serene63522353serene
serer55935503sere_r
seres55448893sere_s
serest64831613serest
serfdom1344203serfdom
serged84118763serged_
served104616813served_
servo84516683ser_vo
sewed95325163sewed_
sexed136618543sexed_
shred98125613shred_
shreds105613053shreds
sired66134283sired_
sored66141783sored_
speedo94011993speedo
stared75429873stared_
steed66024943ste_ed_
steeds73814883ste_eds
steered83615253steered_
stere55328543stere__
stereos74314973stereos
steres63929533stere_s
stewed104814243stewed_
stored75524213stored_
tabered103311593tabered_
tamed85528513tamed_
taped85327423taped_
tapered102612933tapered_
tardy94720463tar_dy
tare45957623tare__
tares57456563tare_s
taro46846913tar__o
tarred74720283tarred_
tarted74923373tarted_
tawed95926193tawed_
taxed135620293taxed_
teamed95418593teamed_
tearer64822903teare_r
tearers75218233tearers
teased74721153teased_
teated74924023teated_
teched124014433teched_
techno1135953techno
ted46446563t__ed_
tedded93810893tedded
tedder83312153tedder
teddy10489493te_ddy
teds54932573t__eds
tee38366873te_e__
teel46335803te_e_l
teels55726373te_els
teem66132603te_e_m
teemed95114873teemed_
teems76019783te_ems
teen45938203te_e_n
teens56227483te_ens
teeny85417883te_eny
tees45353583te_e_s
teeth87315853te_eth
teiid6312533teiid_
teiids736693teiids
teind6213613teind_
teinds738263teinds
telco7511873te_lco
tele45040873tele__
telecom1146813telecom
teledus835093teledus
telega736773telega
teles54536003tele_s
telex125214823tele_x
temped113912893temped_
tempo95214973te_mpo
tend56433773te_nd_
tended83819483tended
tender74121843tender
tendon7312033te_ndon
tends65425583te_nds
tendu67216003te_ndu
tenet55542213tene_t
tenets65518953tenets
tenrec837513tenre_c
tenrecs936033tenrecs
tensed74817833tensed_
tented74221003tented_
tenured838363tenured_
tenuto648743tenuto
tepee74724213tepe_e
tepees84215243tepees
tepefy1434803tepefy
tepid8314313tepid_
terai53525483ter_ai
terais64023503terais
teraph11319093teraph
terbia8311153terbia
terbic10410963terbic
terce75721843ter_ce
tercel83612993tercel
tercels94110363tercels
terces83921413terces
tercet83624913tercet
tercets93512443tercets
terebic1137983terebic
terefah1344113terefah
terga63315643ter_ga
tergal72912833tergal
tergum937933tergum
term66233153ter__m
termer85717253termer
termers95414503termers
termly1138433termly
termor84412513termor
terms75523473ter_ms
tern46134803ter__n
terne56426153ter_ne
ternes65422903ternes
ternion739493ternion
terns55226873ter_ns
terpene92310853terpene
terra54419653ter_ra
terrae62915203terrae
terras63516953terras
terreen7257573terreen
terrene72411033terrene
terret63425623terret
terrets72913573terrets
territ63421373territ
terror63811723terror
terry84721873ter_ry
terse55026823ter_se
tersely1038103tersely
terser67317823terser
tersest71713993tersest
tested74421523tested_
testudo843363testudo
tetrad73612053tetrad_
tetrads82910173tetrads
tetrode839333tetrode
themed125912583themed_
there87527393there__
thereat104315243thereat
thereby1534633thereby
therefor1494453therefor
therein102310353therein
thereof13168063thereof
thereon10199263thereon
theres96525473there_s
thread105011093thread
threads11419953threads
thready14435903thready
threap11569663threap
threat95020463threat
three87526913thre_e
threep115910113threep
threes97117323threes
thresh12276863thresh
threw1117315713thre_w
thro77726423thr__o
tided76322513tided_
tied55535213t_ied_
tierced10347053tierced_
tiled64832943tiled_
timed85223613timed_
tined65434533tined_
tirade7311693tirade
tire46143353tire__
tireder837703tireder
tiredly1136783tiredly
tires55437493tire_s
tirled74714363tirled_
tiro46832363tir__o
toed56137043t_oed_
toked105626493toked_
toled65934923toled_
toledos8388853toledos
tondo69718683t_ondo
toned65435343toned_
toped85631313toped_
tore47359323tore__
toreador944983toreador
toreros7311343toreros
tores55352673tore_s
tornado845663tornado
toro48045683tor__o
torpedos1143923torpedos
torso56922143tor_so
toted64929483toted_
toured74216153toured_
towed95134583towed_
towered112911403towered_
toyed96019803toyed_
trad55630913t_rad_
trade65026043t_rade
tread64821703t_read
treads74817913treads
treat56240353t_reat
tree47745813t_re_e
treen55622753t_reen
treens65317873treens
trees55835763t_rees
treetop945523treetop
tref77030993t_re_f
trek86222313t_re_k
treks96016853t_reks
tremor84210393t_remor
trend64817453t_rend
trends75513543trends
trendy10469603trendy
tres46542903t_re_s
tress55423163t_ress
tret46653533t_re_t
trets55928023t_rets
trews86118893t_rews
trey77228793t_re_y
treys85018213t_reys
tried65026913tried_
trigo65716053t_rigo
trio45233343t_r_io
trod57627953t_rod_
trode65322853t_rode
trued65117693trued_
tsked105910033tsked_
tubed85818043tubed_
tuned64622313tuned_
tupelo836483tupelo
turaco839453turaco
turbo71015043tur_bo
turd56027623tur_d_
turds65021693tur_ds
tureen63312723tureen
turfed103110963turfed_
turned73914473turned_
tuxedos1543283tuxedos
tweed94915093tweed_
tweeds10498433tweeds
tweedy13455933tweedy
tyned95915013tyned_
typed115815453typed_
tyre75428253tyre__
tyres84725233tyre_s
tyro76622363tyr__o
uredos73910623_uredos
uttered82712433uttered_
veered103612743veered_
verged114815153verged_
versed104515513versed_
verso85314633ver_so
vexed165713113vexed_
vireo84816453vire_o
wared96339873wared_
watered113014953watered_
weed85637513we_ed_
weeds95222213we_eds
weedy125115003we_edy
weirdo10405883weirdo
were76238333were__
whereto1346063whereto
wired95327643wired_
yerked14509373yerked_
zero134822463zer__o
zeroed16409413zeroed_

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127164995.43620735.1
3Display Results4994990.1563198.7
 (SQL Overall)1786914995.71531267.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.