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

183 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
chow12582099(None) 
cahow135110941cahow
chaw126224631chaw
chew126622131chew
chon96627791chon
chop116024921chop
chows135618201chows
cow89856711c_ow
crow96428131crow
dhow116614001dhow
how97252431_how
show106229181show
achoo10315082achoo
ahoy101919182ahoy
alow75328592alow
avow107816462avow
blow95827192blow
bow87051902_bow
brow97228442brow
cahows14399122cahows
caw86647932c_aw
chad105525502chad
chai95929902chai
cham115532312cham
chao95727312chao
chaos105622862chaos
chap114928492chap
char95132152char
chat95546132chat
chaws135022462chaws
chay124924872chay
chef125125622chef
chews135418512chews
chewy165011902chewy
chez184519022chez
chi86228652ch_i
chia96026622chia
chic115925202chic
chid106626402chid
chin96934742chin
chip116726422chip
chis95933312chis
chit96937462chit
chock164316612chock
choir105313592choir
choke145118022choke
choky175711222choky
chola104718032chola
cholo105217972cholo
chomp144815662chomp
chook146015042chook
chops125019872chops
chord115917262chord
chore105126762chore
chose105925402chose
chott103923922chott
chowed154914642chowed
chowse144711752chowse
chub115516412chub
chug105914112chug
chum116318002chum
cion613330912cion
claw95624342claw
clew95520572clew
clod76124612clod
clog76123242clog
clon66232482clon
clop86929892clop
clot66542422clot
clown105214732clown
cloy96623832cloy
cob710258752c_ob
cod69660122c_od
cog69552902c_og
coho97524492coho
cohog117813042cohog
cohos105921852cohos
col59360352c_ol
con510268022c_on
coo59566362c_oo
coof96643272coof
cook107236932cook
cool66940492cool
coon67248942coon
coop87238652coop
coos67456492coos
coot67860382coot
cop711162372c_op
cor59960942c_or
cos510270392c_os
cot510483222c_ot
cowl97530812c_owl
cows97046642c_ows
cowy126427362c_owy
cox1210346782c_ox
coy810557552c_oy
coz149345362c_oz
craw97725262craw
crew96122672crew
croc85723732croc
crop87628632crop
crowd115815622crowd
crown105620082crown
crows105727312crows
dhows125911222dhows
dow76749972_dow
echo96615952echo_
echos105216462echos
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
hot67776052_hot
howe106734102_howe
howf136127202_howf
howk145221962_howk
howl107625692_howl
hows106345602_hows
hoy97447912_hoy
ichor1039472ichor
jow137639302_jow
know116115842know
low66051872_low
meow95117882meow
mho86624622mho_
mhos95517772mhos
mow86650352_mow
nohow1137292nohow
now65950192_now
oho66534382oho_
ow58950172__ow
phew128417112phew
phon95925382phon
phot95534352phot
plow95923232plow
pow87147282_pow
prow97030382prow
rho65924832rho_
rhos76319062rhos
row67453672_row
scow96021422scow
shaw108132552shaw
shew108030762shew
shod86225052shod
shoe75933432shoe
shog86025132shog
shoo75929882shoo
shop95629832shop
shot76150242shot
shown115216472shown
shows115324572shows
showy145714002showy
slow77729492slow
snow76324792snow
sow66554762_sow
stow77325742stow
thaw107521312thaw
thew108226232thew
tho67433962tho_
thou76722212thou
throw118719732throw
tow610557362_tow
trow78031422trow
vow96136312_vow
vrow105817472vrow
whew137618782whew
who95526772who_
whoa106615202whoa
whom127018172whom
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 Limit298721830.97030795.9
3Display Results1831830.0463978.3
 (SQL Overall)1786911831.096163039.2
 
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.