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

372 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
snotty948920(None) 
knotty13315221knotty
snooty94211511snooty
snouty9419951snouty
spotty11448581spotty
blotty11178342blotty
clotty11208262clotty
dotty94516102_dotty
gnatty10336482gnatty
grotty10389832grotty
jotty155012602_jotty
natty85719142_natty
netty85816762_netty
nitty85418312_nitty
nutty84816872_nutty
plotty11208852plotty
potty105621002_potty
scatty115310652scatty
shitty124110062shitty
shorty124313202shorty
shott85332192shott_
shotts93614702shotts
slitty9329162slitty
slutty9248002slutty
smutty11266322smutty
snobby1334402snobby
snoopy11449472snoopy
snoot55030142snoot_
snoots64216682snoots
snoozy18517232snoozy
snort54833752snort_
snorts64116502snorts
snot44745452sno_t_
snots55225122sno_ts
snottily1145552snottily
snout54530632snout_
snouts64915872snouts
snowy115011562sno_wy
softy115414482s_ofty
sooty84924842s_ooty
sporty115112492sporty
stott56929792stott_
stotts64612862stotts
agouty10366913agouty
anatto6139913anatto
anomy105113393ano_my
antsy85712793an_tsy
arnotto7134733arnotto
batty105422243_batty
bitty106119173_bitty
blotto8198443blotto
booty106125913_booty
borty105522833_borty
bothy136713963_bothy
bott66548573_bott_
botts75224863_botts
bratty1159683bratty
brothy14519623brothy
butty104020113_butty
catty104520413_catty
chatty14419363chatty
chitty14329433chitty
chott103923933chott_
chotts113610993chotts
cotta75818573_cotta
cutty105417223_cutty
ditty95019293_ditty
dorty96220813_dorty
doty86128223_do_ty
enmity1137483enmity
entity9312053entity
entry82414263en_try
fatty115117413_fatty
floaty124210943floaty
footsy12587933footsy
footy115820533_footy
forty114824273_forty
fretty1249223fretty
frosty124710633frosty
frothy15578373frothy
ghosty13467213ghosty
gouty95217363_gouty
gritty10338403gritty
grotto7349813grotto
grouty104710983grouty
gutty94516993_gutty
hooty115022443_hooty
hotly115815483_hotly
jetty156212583_jetty
jolty155713033_jolty
jutty154914643_jutty
kitty124614563_kitty
knobby1732713knobby
knolly13336133knolly
knot85630503kno_t_
knots95614723kno_ts
knotted12357233knotted
knotter11317643knotter
knottily1543153knottily
knout95018263knout_
knouts10438313knouts
lofty115813303_lofty
lotte54923853_lotte
lotto55217573_lotto
motey105922953_motey
mothy136214553_mothy
mott66648443_mott_
motte75526973_motte
motto76119513_motto
motts76527003_motts
nasty85717283_nasty
nett46643233_nett_
nettly9459453_nettly
netts55320723_netts
nifty115211633_nifty
nobby125513463_nobby
nobly105314403_nobly
noddy105411203_noddy
noily86120993_noily
noisy86813363_noisy
nooky124814813_nooky
north86018273_north
nosey85619883_nosey
nosy76322893_no_sy
not39474663_no_t_
nota46830773_no_ta
notal55221353_notal
notary92310713_notary
notate63217863_notate
notch105613323_notch
note46239963_no_te
noted65123843_noted
noter55025643_noter
notes55034583_notes
notify1236943_notify
notum7611693_notum
noway111112843_noway
nowt78833753_nowt_
nowts86915863_nowts
nutsy85711503_nutsy
otto45220643__otto
patty104723613_patty
petty105320293_petty
potsy105815613_potsy
potto75320943_potto
pouty107018813_pouty
pretty11510873pretty
putty104721403_putty
ratty84819593_ratty
rooty86423023_rooty
rotte54625933_rotte
rutty85617803_rutty
safety12206913safety
salty85524383s_alty
sanctity1345593sanctity
sanity9316203sanity
satay84718463s_atay
scanty114014663scanty
scatt76030093scatt_
scatts85914663scatts
scoot75729153scoot_
scoots85315943scoots
scot66242613sco_t_
scotch13207523scotch
scoter83815483scoter
scotia8310803scotia
scots74025913sco_ts
scottie937463scottie
scout75031453scout_
scouth115011153scouth
scouts84817943scouts
sentry92912053sentry
sett45949053s_ett_
setts55124323s_etts
shanty124715123shanty
shelty124011553shelty
shifty15409263shifty
shirty124312563shirty
shoaly124010773shoaly
shoat85633953shoat_
shoats94117083shoats
shoddy1434543shoddy
shoot84235913shoot_
shoots94619363shoots
short85040533short_
shortly13387573shortly
shorts95321743shorts
shot76150263sho_t_
shote85526103sho_te
shotes95321913shotes
shots84730853sho_ts
shotted113912403shotted
shotten10288463shotten
shout85433173shout_
shouts94017723shouts
showy145714013sho_wy
silty84721633s_ilty
sixty154912733s_ixty
skort94925643skort_
skorts104211303skorts
slanty95114843slanty
slatey95417063slatey
slaty86523153s_laty
sleety94112653sleety
slobby1334803slobby
sloppy1395303sloppy
sloshy12366623sloshy
slot46049833slo_t_
sloth85019453slo_th
sloths94911893sloths
slots54830533slo_ts
slotted84613883slotted
slotter73314453slotter
slowly1237153slowly
smarty115013793smarty
smithy14508273smithy
smoggy1354283smoggy
smokey15398653smokey
smoky14388683smo_ky
smolt74824163smolt_
smolts84411883smolts
smooth11259203smooth
smoothy15205083smoothy
smote75820283smo_te
snaggy11488053snaggy
snakey135011273snakey
snaky125113913sn_aky
snappy1366103snappy
snarky134210843snarky
snarly93815003snarly
snatch114310603snatch
snatchy15355293snatchy
snath86419803sn_ath
snathe94415113snathe
snaths95112913snaths
snazzy1734013snazzy
sneaky13427843sneaky
sneery93610413sneery
sneezy18345273sneezy
sniffy15337193sniffy
snippy1374843snippy
snit46342473sn_it_
snitch11357943snitch
snits54124833sn_its
snob65825593sno__b
snobs74716153sno_bs
snog55623633sno__g
snogs66017493sno_gs
snood64616163sno_od
snoods74312453snoods
snook95115573sno_ok
snooks104412833snooks
snool55118643sno_ol
snools65715883snools
snoop75317173sno_op
snoops84314173snoops
snooted84213283snooted
snootily1136253snootily
snooze15439993snooze
snore55424953sno_re
snored74819543snored
snorer64316763snorer
snores64324323snores
snorted83813493snorted
snorter74412663snorter
snottier8217383snottier
snouted84311343snouted
snow76324793sno__w
snowed104613623snowed
snowily1336883snowily
snows84719893sno_ws
snubby1344533snubby
snuffy15356243snuffy
snugly1055663snugly
soapy106114783s_oapy
soddy104210703s_oddy
soft76942823s_oft_
softa86415183s_ofta
softly12457763softly
softs85019233s_ofts
soggy105413903s_oggy
sonata6313223sonata
sonly85718053s_only
sonny85016103s_onny
sonority1148533sonority
sonsy86416373s_onsy
sooey84522433s_ooey
soot45761063s_oot_
sooted73922593sooted
sooth85924063s_ooth
soothe94214853soothe
soothly13186923soothly
sooths95715593sooths
sootily101810523sootily
soots55536213s_oots
sophy136611763s_ophy
soppy125113523s_oppy
sorry84618253s_orry
sort46264813s_ort_
sorta57125413s_orta
sorts54536663s_orts
sot310384303s_o_t_
soth75932523s_o_th
soths86218633s_oths
sotol54917653s_otol
sots45552453s_o_ts
sotted74121403s_otted
soupy106115403s_oupy
south85223573s_outh
soy67851453s_o__y
spongy1236743spongy
spoofy14498553spoofy
spooky15418093spooky
spoony114111793spoony
sport75935983sport_
sports84619183sports
spot65540693spo_t_
spots74424113spo_ts
spotted103713143spotted
spotter94514883spotter
spottily1335153spottily
spout75029633spout_
spouts85115113spouts
squatty1964823squatty
stay78333723s__tay
stey76224413s__tey
stithy12398213stithy
stoat57135953stoat_
stoats65117483stoats
stocky15369153stocky
stodgy11415733stodgy
stogey105811543stogey
stogy95414083sto_gy
stoney96217353stoney
stony85818643sto_ny
stopt76528353stopt_
storey95217613storey
stormy115510733stormy
story86723033sto_ry
stot46347333sto_t_
stotin63215063stotin
stots54828553sto_ts
stotted83511423stotted
stoury9529943stoury
stout57434053stout_
stoutly1035833stoutly
stouts65019003stouts
sty66227313s___ty
subtly11249263subtly
suety85318493s_uety
sultry938463sultry
surety93515013surety
sutta54015333s_utta
swarty125812383swarty
sweaty123710053sweaty
swoony12408263swoony
swoopy14487283swoopy
swot75134663swo_t_
swots85518433swo_ts
swotted11398713swotted
swotter10399473swotter
syntony1344523syntony
tatty84720183_tatty
titty85316653_titty
toothy12529693toothy
tootsy9437983tootsy
trouty95211793trouty
tutty85217023_tutty
unity84918493un_ity
witty114717013_witty
zloty17399793zlo_ty
zooty175415353_zooty

Search took 7 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.373479064.3
2DLD Change Limit1127163725.62620034.8
3Display Results3723720.1233024.4
 (SQL Overall)1786913726.12229188.3
 
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.