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

133 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
knot8563050(None) 
knit85728141knit
knob107417011knob
knop107116591knop
knots95614721knots
knout95018261knout
know116115841know
not39474661_not
snot44745451snot
anoa45634472anoa
anon46134852anon
ant37270792an_t
beknot1239762beknot
blot65842322blot
boot67759372boot
bot59680402_bot
clot66542422clot
coot67860382coot
cot510483222_cot
dot47573182_dot
enol45823822enol
enow77819872enow
font77143752font
foot76248012foot
gnat56034432gnat
got49870442_got
grot55942052grot
hoot75752102hoot
hot67776062_hot
ingot61221062ingot
into45026152into
jot108259022_jot
kaon87521022kaon
kart86750802kart
kat77468292k_at
keet85347332keet
kelt85343192kelt
keno87926432keno_
kenos95220622kenos
kent86846962kent
kept106232942kept
keto86223452keto
khat116730722khat
khet116328622khet
kilt86144412kilt
kino86233612kino_
kinos96626142kinos
kist86540792kist
kit78559872k_it
knap105815402knap
knar85818722knar
knee85323602knee
knelt94617682knelt
knew115912122knew
knits93914742knits
knobs11519712knobs
knock10487962knock
knoll9389602knoll
knops115911812knops
knosp11576822knosp
knotty13315222knotty
knouts10438312knouts
known12568342known
knows124912412knows
knur85311972knur
koa76737772k_oa
kob99442382k_ob
koi77534752k_oi
konk79320612konk
kook75822602kook
kop97440202k_op
kor76538892k_or
kos76944822k_os
koto86323472k_oto
kyat116025522kyat
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
reknot10311732reknot
riot45947212riot
root45655922root
rot37282952_rot
ryot75528562ryot
scot66242612scot
shot76150262shot
slot46049832slot
snit46342472snit
snob65825592snob
snog55623632snog
snoot55030142snoot
snort54833752snort
snots55225122snots
snout54530632snout
snow76324792snow
soot45761062soot
sot310384302_sot
spot65540692spot
stot46347332stot
swot75134662swot
toot45958882toot
tot38884772_tot
trot46351312trot
ungot61718062ungot
unit45140072unit
unknot1037412unknot
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.1401276364.3
2DLD Change Limit298721331.56319112.0
3Display Results1331330.0304433.3
 (SQL Overall)1786911331.733103110.8
 
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.