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 “trot” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

263 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
trot4635131(None) 
grot55942051grot
rot37282951_rot
tarot55943931tarot
toot45958881toot
torot56139941torot
tort46967461tort
tot38884771t_ot
tret46653531tret
trod57627951trod
trog57628211trog
trop66833301trop
troth85622201troth
trots56629941trots
trout57332571trout
trow78031421trow
troy77429681troy
argot67728652argot
art38679142ar_t
blot65842322blot
boot67759372boot
bort65960962bort
bot59680402_bot
brat66055542brat
brit66350152brit
bro56236602bro_
broo65129822broo
bros65635662bros
broth106521092broth
brow97228442brow
brut66537962brut
clot66542422clot
coot67860382coot
cot510483222_cot
crit65743712crit
croc85723732croc
croft105622682croft
crop87628632crop
crow96428132crow
dot47573182_dot
drat56247832drat
droit65127122droit
drop75324402drop
dropt86924432dropt
ergot65422892ergot
eros45238452eros
erst47436432erst
foot76248012foot
fort76456442fort
frat75648542frat
fret75845042fret
frit77044472frit
fro65530642fro_
froe75329992froe
frog85624362frog
from96923922from
front85029222front
frost84727832frost
froth115919282froth
frow106425052frow
got49870442_got
grat55651282grat
griot65328412griot
grit55247242grit
groat65531972groat
grog65923342grog
grok95819682grok
grots65025852grots
grout65330422grout
grow86127302grow
hoot75752102hoot
hot67776062_hot
iron46728462iron
jot108259022_jot
knot85630502knot
lirot5430032lirot
loot46955822loot
lot38179262_lot
moot67653622moot
mort66758832mort
mot57279422_mot
not39474662_not
oot311274692_oot
ort39465232or_t
phot95534362phot
plot66141232plot
port66059632port
pot58078432_pot
prat65952042prat
pro55837262pro_
proa66229962proa
prod76129502prod
prof96134662prof
prog75729002prog
prom87631702prom
prop85932812prop
pros65742782pros
prost75434102prost
prow97030382prow
rat37892742_rat
ret35982832_ret
riot45947212riot
rob56754302_rob
roc520243252_roc
rod47953892_rod
roe36861082_roe
rom59855632_rom
root45655922root
rota45834342_rota
rote46249022_rote
roti46332932_roti
rotl45029682_rotl
roto45935052_roto
rots46454092_rots
rout46153282_rout
row67453672_row
rut35560522_rut
ryot75528562ryot
scot66242612scot
shot76150262shot
slot46049832slot
snot44745452snot
soot45761062soot
sort46264812sort
sot310384302_sot
spot65540692spot
stot46347332stot
strop77422242strop
strow88920572strow
stroy87720392stroy
strut56030732strut
swot75134662swot
tact67349032tact
tao38358952tao_
taos45541002taos
taro46846912taro_
taroc75721642taroc
tarok97921072tarok
taros55640822taros
tarots66422992tarots
tart47566182tart
tat37690292t_at
taut47048962taut
teat45963632teat
tent46159862tent
test48651622test
tet39274992t_et
text116033932text
that75639322that
tho67433962tho_
thou76722212thou
thro77726422thro_
throat94819752throat
throb109816852throb
throe89321422throe
throw118719732throw
tilt46252422tilt
tint46758862tint
tiro46832362tiro_
tiros54524892tiros
tit36771052t_it
to218858982t_o_
tod49457072t_od
toe310166852t_oe
toft77441652toft
tog410255042t_og
toit46353062toit
tom514358052t_om
ton310265102t_on
too38965422t_oo
took86531072took
tool46735682tool
toom66532932toom
toon47740632toon
tooth88020182tooth
toots55331872toots
top510560682t_op
tor39261682t_or
tora47545992tora
torc66333352torc
tore47359322tore
tori47542152tori
torn46044252torn
toro48045682toro
toros54336192toros
toroth95512962toroth
torr45630902torr
tors46157382tors
torta55925352torta
torte55431702torte
torts56138122torts
tory75840542tory
tost48351922tost
tote46643672t_ote
tots46654122t_ots
tout46753822tout
tow610557362t_ow
toy69655192t_oy
tract75635712tract
trad55630912trad
trait56940842trait
tram67034552tram
trap67532802trap
trapt76433392trapt
tray77632592tray
treat56240352treat
tree47745812tree
tref77030992tref
trek86222312trek
tres46542902tres
trets55928022trets
trey77228792trey
tricot8317752tricot
trig55528162trig
trim65329522trim
trio45233342trio
triol55521362triol
trios55528092trios
trip66830392trip
trite54730032trite
troak95213572troak
trock114817602trock
trode65322852trode
trogs67022602trogs
trois57226092trois
troke94821052troke
troll54416532troll
tromp95815802tromp
trona54118952trona
trone55131862trone
troop76417532troop
trooz145016152trooz
trope75725802trope
troths95414152troths
trotyl9236672trotyl
trouts66116632trouts
trouty95211792trouty
trove85221922trove
trows88826182trows
trowth1277882trowth
troys86418612troys
true46725852true
trug55720042trug
trust55426852trust
truth85214152truth
try66529672tr_y
tryout9410762tryout
tryst84716222tryst
tuft76929512tuft
turbot8914262turbot
tut36758092t_ut
twat75831512twat
twit76329062twit
two67925832two_
twos76718022twos
tyro76622362tyro_
tyros85118592tyros
vrow105817472vrow
wort76654752wort
wot610467482_wot
writ75537912writ
wrote84717482wrote
wroth116815882wroth

Search took 2 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 Filter178691298720.263679433.5
2DLD Change Limit298722630.97030795.9
3Display Results2632630.0634174.6
 (SQL Overall)1786912631.296137878.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.