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

218 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
snot4474545(None) 
knot85630501knot
not39474661_not
scot66242611scot
shot76150261shot
slot46049831slot
snit46342471snit
snob65825591snob
snog55623631snog
snoot55030141snoot
snort54833751snort
snots55225121snots
snout54530631snout
snow76324791snow
soot45761061soot
sot310384301s_ot
spot65540691spot
stot46347331stot
swot75134661swot
anoa45634472anoa
anon46134852anon
ant37270792an_t
ascot76522512ascot
blot65842322blot
boot67759372boot
bot59680402_bot
clot66542422clot
coot67860382coot
cot510483222_cot
dot47573182_dot
enol45823822enol
enow77819872enow
escot75320082escot
font77143752font
foot76248012foot
gnat56034432gnat
got49870442_got
grot55942052grot
hoot75752102hoot
hot67776062_hot
ingot61221062ingot
into45026152into
jot108259022_jot
knit85728142knit
knob107417012knob
knop107116592knop
knots95614722knots
knout95018262knout
know116115842know
loot46955822loot
lot38179262_lot
moot67653622moot
mot57279422_mot
net36670292_net
nit37065942_nit
no29353242_no_
nob58954422_nob
nod47549562_nod
nog46847312_nog
noh66640642_noh
nom510450642_nom
noo37154042_noo
nor38048822_nor
nos38859322_nos
nota46830772_nota
note46239962_note
now65950192_now
nowt78833752_nowt
nut36651962_nut
ono36838032ono_
onos46229002onos
onto46127662onto
oot311274692_oot
phot95534362phot
pinot78737292pinot
plot66141232plot
pot58078432_pot
riot45947212riot
root45655922root
rot37282952_rot
ryot75528562ryot
sabot7931782sabot
salt45758522salt
santo56227282santo
sat36288482s_at
scat65848372scat
scoot75729152scoot
scop85925522scop
scots74025912scots
scout75031452scout
scow96021422scow
scut65835542scut
seat47575562seat
sect67443622sect
senor53822792senor
sent46963012sent
sept65844362sept
set36681252s_et
sett45949052sett
sext117338092sext
shat76456602shat
shit76745942shit
shoat85633952shoat
shod86225062shod
shoe75933442shoe
shog86025142shog
shoo75929892shoo
shoot84235912shoot
shop95629842shop
short85040532short
shote85526102shote
shots84730852shots
shott85332192shott
shout85433172shout
show106229192show
shut76137592shut
sift710740662sift
silt46558192silt
sit35877752s_it
skat87037902skat
skit85437532skit
skort94925642skort
slat46959022slat
slit46250102slit
slob66029422slob
sloe45534952sloe
slog56728272slog
slop66533872slop
sloth85019452sloth
slots54830532slots
slow77729492slow
slut45040592slut
smit65138412smit
smog76317412smog
smolt74824162smolt
smote75820282smote
smut66629782smut
snag55827872snag
snap65727032snap
snath86419802snath
snaw78923072snaw
sned56026052sned
snib66522982snib
snip66424652snip
snits54124832snits
snobs74716152snobs
snogs66017492snogs
snood64616162snood
snook95115572snook
snool55118642snool
snoop75317172snoop
snoots64216682snoots
snooty94211512snooty
snore55424952snore
snorts64116502snorts
snotty9489202snotty
snouts64915872snouts
snouty9419952snouty
snows84719892snows
snowy115011562snowy
snub65320762snub
snug55218692snug
snye77115492snye
so28855442s_o_
sob57857942s_ob
sod46053702s_od
soft76942822soft
sol37256622s_ol
som59153812s_om
son37761952s_on
sone46649982sone
song55133672song
sons46049552sons
sook84933392sook
soon46240502soon
sooth85924062sooth
soots55536212soots
sooty84924842sooty
sop57557862s_op
sort46264812sort
sos37761602s_os
soth75932522s_oth
sots45552452s_ots
sou37853692s_ou
sow66554762s_ow
sox106444192s_ox
soy67851452s_oy
spat66548522spat
spit65545082spit
sport75935982sport
spots74424112spots
spout75029632spout
stat47352692stat
stet45947322stet
stoa45425912stoa
stoat57135952stoat
stob66724612stob
stop66532032stop
stopt76528352stopt
stots54828552stots
stott56929792stott
stout57434052stout
stow77325742stow
suet46754822suet
suit45649872suit
swat77244442swat
swob95218632swob
swop95120502swop
swots85518432swots
synod9610282synod
toot45958882toot
tot38884772_tot
trot46351312trot
ungot61718062ungot
unit45140072unit
unto45824282unto
wont75842502wont
wot610467482_wot

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.0762351197.4
2DLD Change Limit298722180.89333451.3
3Display Results2182180.0603633.3
 (SQL Overall)1786912181.029173655.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.