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

213 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
show10622919(None) 
chow125820991chow
dhow116614001dhow
how97252431_how
scow96021421scow
shaw108132551shaw
shew108030761shew
shod86225061shod
shoe75933441shoe
shog86025141shog
shoo75929891shoo
shop95629841shop
shot76150261shot
shown115216481shown
shows115324581shows
showy145714011showy
slow77729491slow
snow76324791snow
sow66554761s_ow
stow77325741stow
ahoy101919182ahoy
alow75328592alow
avow107816462avow
blow95827192blow
bow87051902_bow
brow97228442brow
cahow135110942cahow
chaw126224632chaw
chew126622132chew
chon96627792chon
chop116024922chop
chows135618202chows
cow89856712_cow
crow96428132crow
dhows125911222dhows
dow76749972_dow
enow77819872enow
flow105924922flow
frow106425052frow
glow85222522glow
grow86127302grow
haw97153272_haw
hew97642722_hew
ho510258272_ho_
hob87550922_hob
hod76852462_hod
hoe67562722_hoe
hog78049062_hog
hon67759382_hon
hop87554592_hop
hos68364192_hos
hot67776062_hot
howe106734102_howe
howf136127202_howf
howk145221962_howk
howl107625692_howl
hows106345602_hows
hoy97447912_hoy
jow137639302_jow
know116115842know
low66051872_low
meow95117882meow
mho86624622mho_
mhos95517772mhos
mow86650352_mow
nohow1137292nohow
now65950192_now
oho66534382oho_
ow58950172__ow
phew128417112phew
phon95925382phon
phot95534362phot
plow95923232plow
pow87147282_pow
prow97030382prow
pshaw13447512pshaw
reshow123111432reshow
rho65924832rho_
rhos76319062rhos
row67453672_row
saw68255352s_aw
scop85925522scop
scot66242612scot
scowl1012012972scowl
scows106617802scows
serow86720442serow
sew66247262s_ew
sh56828522sh__
sha69837782sh_a
shad86230912shad
shadow1337252shadow
shag86430562shag
shah105627782shah
sham96436362sham
shat76456602shat
shawl116217572shawl
shawm135316152shawm
shawn116417612shawn
shaws116226262shaws
shay107133342shay
she66837692sh_e
shea76031572shea
shed86536152shed
sheol84318372sheol
shes75734352shes
shewn115715702shewn
shews115924712shews
shh97121072sh_h
shim95827862shim
shin75634312shin
ship95228242ship
shit76745942shit
shiv105721172shiv
shmo95318102shmo
shoal83920272shoal
shoat85633952shoat
shock144917032shock
shoed95723012shoed
shoer84722162shoer
shoes85429662shoes
shogi95014012shogi
shogs95319712shogs
shoji15419962shoji
shone83725982shone
shook124920162shook
shool84523152shool
shoon84022012shoon
shoos84226362shoos
shoot84235912shoot
shops104222902shops
shore85432652shore
shorl84720252shorl
shorn85722182shorn
short85040532short
shote85526102shote
shots84730852shots
shott85332192shott
shout85433172shout
shove114421042shove
showed135016972showed
shower124315112shower
shoyu1138912shoyu
shrew119720162shrew
shri76021702shri
shul75823152shul
shun75122772shun
shut76137592shut
shwa106014962shwa
shy96728192sh_y
skew116218762skew
slaw77930712slaw
slew76228232slew
slob66029422slob
sloe45534952sloe
slog56728272slog
slop66533872slop
slot46049832slot
slows85323462slows
smew95017732smew
smog76317412smog
snaw78923072snaw
snob65825592snob
snog55623632snog
snot44745452snot
snows84719892snows
snowy115011562snowy
so28855442s_o_
sob57857942s_ob
sod46053702s_od
sol37256622s_ol
som59153812s_om
son37761952s_on
sook84933392sook
soon46240502soon
soot45761062soot
sop57557862s_op
sos37761602s_os
sot310384302s_ot
sou37853692s_ou
sown75127452s_own
sows75342492s_ows
sox106444192s_ox
soy67851452s_oy
spew95421872spew
spot65540692spot
staw78627692staw
stew77525462stew
stoa45425912stoa
stob66724612stob
stop66532032stop
stot46347332stot
stowp105614232stowp
stows86622702stows
strow88920572strow
swob95218632swob
swop95120502swop
swot75134662swot
thaw107521312thaw
thew108226232thew
tho67433962tho_
thou76722212thou
throw118719732throw
tow610557362_tow
trow78031422trow
vow96136312_vow
vrow105817472vrow
whew137618782whew
who95526772who_
whoa106615202whoa
whom127018182whom
whop125520922whop
wow96643472_wow
yow96945292_yow

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.0802233637.5
2DLD Change Limit298722131.32622527.9
3Display Results2132130.0464630.4
 (SQL Overall)1786912131.452123065.4
 
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.