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

276 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
shoe7593344(None) 
hoe67562721_hoe
she66837691sh_e
shod86225061shod
shoed95723011shoed
shoer84722161shoer
shoes85429661shoes
shog86025141shog
shone83725981shone
shoo75929891shoo
shop95629841shop
shore85432651shore
shot76150261shot
shote85526101shote
shove114421041shove
show106229191show
sloe45534951sloe
ahoy101919182ahoy
aloe45540192aloe
ashore9414612ashore
choke145118022choke
chon96627792chon
chop116024922chop
chore105126762chore
chose105925402chose
chow125820992chow
dhole95215362dhole
dhow116614002dhow
doe47361952_doe
floe76129772floe
foe66350812_foe
froe75329992froe
ghee85726112ghee
hae67364002_hae
he58151952_h_e
hie67652702_hie
ho510258272_ho_
hob87550922_hob
hod76852462_hod
hoed87837982_hoed
hoer76533982_hoer
hoes75755732_hoes
hog78049062_hog
hoke115935932_hoke
hole77553392_hole
home98042442_home
hon67759382_hon
hone77549322_hone
hop87554592_hop
hope96639672_hope
hos68364192_hos
hose76547242_hose
hot67776062_hot
hove107132222_hove
how97252432_how
howe106734102_howe
hoy97447912_hoy
hue66642302_hue
joe106642352_joe
mahoe10315572mahoe
mho86624622mho_
mhos95517772mhos
oboe66822942oboe
oe28473062__oe
oho66534382oho_
phon95925382phon
phone105621932phone
phot95534362phot
reshoe92816482reshoe
rho65924832rho_
rhos76319062rhos
roe36861082_roe
sabe66140572sabe
sade55544472sade
sae38365182s_ae
safe75930952safe
sage55044592sage
sake85244962sake
sale44959702sale
same65245642same
sane45954342sane
sate45556102sate
save75741362save
schmoe13328332schmoe
scone74621832scone
scop85925522scop
scope94821482scope
score75526742score
scot66242612scot
scow96021422scow
see35772262s_ee
seme65836652seme
sene46848052sene
sere46153472sere
sh56828522sh__
sha69837782sh_a
shad86230912shad
shade95125582shade
shag86430562shag
shah105627782shah
shake124726402shake
shale85332832shale
sham96436362sham
shame105726702shame
shape105125112shape
share86437082share
shat76456602shat
shave114425892shave
shaw108132552shaw
shay107133342shay
shea76031572shea
shed86536152shed
sheen85023312sheen
sheep105321522sheep
sheer84726892sheer
sheet84836962sheet
sheol84318372sheol
shes75734352shes
shew108030762shew
shh97121072sh_h
shied96125492shied
shiel811023772shiel
shier85428942shier
shies86136552shies
shim95827862shim
shin75634312shin
shine85533092shine
ship95228242ship
shire84727132shire
shit76745942shit
shiv105721172shiv
shive114423422shive
shlep104914832shlep
shmo95318102shmo
shmoes114612102shmoes
shoal83920272shoal
shoat85633952shoat
shock144917032shock
shoers94518332shoers
shogi95014012shogi
shogs95319712shogs
shoji15419962shoji
shooed103916082shooed
shook124920162shook
shool84523152shool
shoon84022012shoon
shoos84226362shoos
shoot84235912shoot
shoppe133110322shoppe
shops104222902shops
shored105723652shored
shores94830412shores
shorl84720252shorl
shorn85722182shorn
short85040532short
shotes95321912shotes
shots84730852shots
shott85332192shott
shout85433172shout
shoved134214282shoved
shovel124611322shovel
shover124515992shover
shoves124919422shoves
showed135016972showed
shower124315112shower
shown115216482shown
shows115324582shows
showy145714012showy
shoyu1138912shoyu
shred98125612shred
shrew119720172shrew
shri76021702shri
shrove125412232shrove
shul75823152shul
shun75122772shun
shut76137592shut
shute84520352shute
shwa106014962shwa
shy96728192sh_y
shyer114714782shyer
sice65545592sice
side55444492side
sike87138782sike
sine46560622sine
sipe67341042sipe
sire46150412sire
site47052412site
size135630962size
skee85431472skee
slob66029422slob
sloes54728872sloes
slog56728272slog
slop66533872slop
slope75823562slope
slot46049832slot
slow77729492slow
slue45332192slue
smog76317412smog
smoke115015822smoke
smote75820282smote
snob65825592snob
snog55623632snog
snore55424952snore
snot44745452snot
snow76324792snow
snye77115492snye
so28855442s_o_
sob57857942s_ob
sod46053702s_od
soke85436262soke
sol37256622s_ol
sole46053672sole
som59153812s_om
some66040382some
son37761952s_on
sone46649982sone
sooey84522432sooey
sook84933392sook
soon46240502soon
soot45761062soot
sop57557862s_op
sore47059532sore
sos37761602s_os
sot310384302s_ot
sou37853692s_ou
sow66554762s_ow
sox106444192s_ox
soy67851452s_oy
spae65034322spae
spode84617702spode
spoke114818662spoke
spore75428592spore
spot65540692spot
spue66025522spue
stoa45425912stoa
stoae55024262stoae
stob66724612stob
stoke94922512stoke
stole54928812stole
stone55431182stone
stop66532032stop
stope74727242stope
store56333812store
stot46347332stot
stove85220252stove
stow77325742stow
stye76218972stye
sue35651462s_ue
supe65932762supe
sure45447412sure
swob95218632swob
swop95120502swop
swore84920822swore
swot75134662swot
syce95820282syce
syke115420562syke
syne75725762syne
thae76825562thae
the67436052th_e
thee78039062thee
tho67433962tho_
thole85620842thole
those85218142those
thou76722212thou
throe89321422throe
toe310166852_toe
voe67739052_voe
whee105429592whee
who95526772who_
whoa106615202whoa
whole114418092whole
whom127018182whom
whop125520922whop
whore116018042whore
whose114914532whose
woe66651242_woe

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.283631417.0
2DLD Change Limit298722760.84335435.3
3Display Results2762760.0604600.0
 (SQL Overall)1786912761.186150666.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.