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

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

232 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
shnook136634(None) 
schnook1654481schnook
shnooks1485581shnooks
shook124920161sh_ook
snook95115571s_nook
chinook1675102chinook
chook146015042ch_ook
hook116133282_h_ook
nook85728492__nook
schnooks1754242schnooks
shlock15378192shlock
shock144917032sh_ock
shoo75929892sh_oo_
shooks134515632sh_ooks
shool84523152sh_ool
shoon84022012sh_oon
shoos84226362sh_oos
shoot84235912sh_oot
snood64616162s_nood
snooks104412832s_nooks
snool55118642s_nool
snoop75317172s_noop
snoot55030142s_noot
sook84933392s__ook
spook115416042s_pook
stook95218212s_took
strook10410302strook
unhook1347522unhook
betook12439603betook
bhoot104322103bh_oot
book106836333__book
brook114717763_brook
cashbook1943493cashbook
chinooks1774783chinooks
chock164316613ch_ock
chooks155312793ch_ooks
cook107236933__cook
crook115217573_crook
ebook114510803_ebook
fishhook2142163fishhook
gook96429603__gook
hock136031303_h_ock
holk116027943_h_olk
honk116931193_h_onk
honor85718623_honor
hood85132333_h_ood
hoof106036583_h_oof
hooka125513903_h_ooka
hooks125027123_h_ooks
hooky155220263_h_ooky
hoop96129983_h_oop
hoot75752103_h_oot
howk145221963_h_owk
knock10487963_knock
kook75822603__kook
look87333473__look
nock106127183__nock
nonbook1346283nonbook
noo37154043__noo_
nooks95420393__nooks
nooky124814813__nooky
noon47134623__noon
phono104917023phono_
phonon114012033phonon
phonos114114793phonos
rebook125213203rebook
recook125513923recook
relook104813743relook
retook104313443retook
rhebok1534613rhebok
rook85532033__rook
saloon64418023saloon
saloop84212583saloop
sanjak1735693sanjak
sank85236833san__k
sannop837373sannop
santo56227283santo_
santol64515243santol
santoor737433santoor
santos64421833santos
schlock18235873schlock
schmoos14347513schmoos
schnoz2035653schn_oz
schnozz2042733schnozz
school11410723school
scoop95617163s_coop
scoot75729153s_coot
scroop10299773scroop
senhor93010803senhor
senior63214043senior
senor53822793sen_or
senora63216153senora
senors63620783senors
sensor63813833sensor
shack145321753sh_ack
shacko153810113shacko
shadoof1446133shadoof
shadow1337253shadow
shako125516093shako_
shakos134912193shakos
shalom11810923shalom
shamos114216983shamos
shamoy14379913shamoy
shank125422193sh_ank
shark126225023sh_ark
sheik122514663sh_eik
sheol84318373sh_eol
sheols94614163sheols
sheroot10414373sheroot
shirk124817843sh_irk
shlocks16317183shlocks
shlocky19314503shlocky
shmo95318103sh_mo_
shmoes114612103shmoes
shmooze21255263shmooze
shmuck1734243shmuck
shnaps1148083shnaps
shoal83920273sh_oal
shoat85633953sh_oat
shocks154414583sh_ocks
shod86225063sh__od
shoe75933443sh__oe
shoed95723013sh_oed
shoer84722163sh_oer
shoes85429663sh_oes
shog86025143sh__og
shogi95014013sh_ogi
shogs95319713sh_ogs
shoji15419963sh_oji
sholom11910113sholom
shone83725983sh_one
shooed103916083shooed
shools94919013shools
shoots94619363shoots
shop95629843sh__op
shops104222903sh_ops
shore85432653sh_ore
shorl84720253sh_orl
shorn85722183sh_orn
short85040533sh_ort
shot76150263sh__ot
shote85526103sh_ote
shots84730853sh_ots
shott85332193sh_ott
shout85433173sh_out
shove114421043sh_ove
show106229193sh__ow
shown115216483sh_own
shows115324583sh_ows
showy145714013sh_owy
shoyu1138913sh_oyu
shrank13359123shrank
shriek134211103shriek
shrink134511733shrink
shroff1538503shroff
shroud1038773shroud
shrove125412233shrove
shrunk13357063shrunk
shtick15308023shtick
shtik123210963sh_tik
shuck144314533sh_uck
shylock1945053shylock
simoom1037503simoom
simoon858063simoon
sink86640143sin__k
skyhook1642583skyhook
sloop76118913s_loop
smock135311673s_mock
snack114718063s_nack
snark95419943s_nark
sneak96016173s_neak
sneck114713663s_neck
snick114416013s_nick
snob65825593s_n_ob
snobs74716153s_nobs
snog55623633s_n_og
snogs66017493s_nogs
snoods74312453s_noods
snooked123711493s_nooked
snooker113910303s_nooker
snools65715883s_nools
snoops84314173s_noops
snoopy11449473s_noopy
snoots64216683s_noots
snooty94211513s_nooty
snooze15439993s_nooze
snoozy18517233s_noozy
snore55424953s_nore
snort54833753s_nort
snot44745453s_n_ot
snots55225123s_nots
snout54530633s_nout
snow76324793s_n_ow
snows84719893s_nows
snowy115011563s_nowy
snuck114411913s_nuck
soak87227663s__oak
sock105233213s__ock
songbook1543633songbook
sonhood1168313sonhood
sonovox1743013sonovox
sooks94425453s__ooks
soon46240503s__oon
soot45761063s__oot
souk86127173s__ouk
spoof105019013s_poof
spooks124312933s_pooks
spooky15418093s_pooky
spool75219043s_pool
spoon74719443s_poon
spoor75016353s_poor
stock114417563s_tock
stood65517713s_tood
stooks105115373s_tooks
stool55619893s_tool
stoop75821543s_toop
stork96819693s_tork
sunbow1145823sunbow
sundog837613sundog
sunk85031813sun__k
sunroof1047053sunroof
sunroom947013sunroom
swoon85014783s_woon
swoop105213433s_woop
syncom1336093syncom
synod9610283syn_od
synods1077953synods
took86531073__took
unhood1039233unhood
unhooks1436413unhooks
whoof144612693wh_oof
whoop134211443wh_oop

Search took 5 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162324.59324540.8
3Display Results2322320.0763052.6
 (SQL Overall)1786912324.80937157.6
 
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.