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

122 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
dhow11661400(None) 
chow125820991chow
dhows125911221dhows
dow76749971d_ow
how97252431_how
show106229191show
ahoy101919182ahoy
alow75328592alow
avow107816462avow
blow95827192blow
bow87051902_bow
brow97228442brow
cahow135110942cahow
chaw126224632chaw
chew126622132chew
chon96627792chon
chop116024922chop
chows135618202chows
cow89856712_cow
crow96428132crow
daw77148362d_aw
dew77139922d_ew
dhak125512032dhak
dhal86719282dhal
dhobi1136972dhobi
dhole95215362dhole
dhoti9310122dhoti
diol57329132diol
do310155252d_o_
doc66841512d_oc
doe47361952d_oe
dog57449752d_og
dol47150652d_ol
dom69752442d_om
don46757652d_on
doom76430072doom
door56928512door
dor47253922d_or
dos48062312d_os
dot47573182d_ot
down86427492d_own
dows85941052d_ows
draw85623012draw
drew86221672drew
drop75324402drop
drown95515822drown
duo48536142duo_
duos56728132duos
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
rho65924832rho_
rhos76319062rhos
row67453672_row
scow96021422scow
shaw108132552shaw
shew108030762shew
shod86225062shod
shoe75933442shoe
shog86025142shog
shoo75929892shoo
shop95629842shop
shot76150262shot
shown115216482shown
shows115324582shows
showy145714012showy
slow77729492slow
snow76324792snow
sow66554762_sow
stow77325742stow
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.300595636.7
2DLD Change Limit298721220.92032469.6
3Display Results1221220.0167625.0
 (SQL Overall)1786911221.236144572.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.