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

124 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
knots9561472(None) 
knits93914741knits
knobs11519711knobs
knops115911811knops
knot85630501knot_
knouts10438311knouts
knows124912411knows
snots55225121snots
anoas57226492anoas
ants47243472an_ts
beknots1335082beknots
blots75626172blots
boots75837972boots
bots66453952_bots
clots75627642clots
coots75636842coots
cots68054842_cots
dots55647662_dots
enols54718402enols
enows85115492enows
fonts86124752fonts
foots85528282foots
gnats65217712gnats
grots65025852grots
hoots84830252hoots
hots78349332_hots
ingots7912062ingots
jots116336142_jots
kaons95014852kaons
karts97630112karts
kats85944332k_ats
keets95123482keets
kelts95222632kelts
kenos95220622keno_s
khats125316012khats
khets124913432khets
kilts95122182kilts
kinos96626142kino_s
kists95822112kists
kits86441772k_its
knaps115511172knaps
knars94416112knars
knees95114872knees
knit85728142knit_
knob107417012kno_b
knock10487962knock
knocks11397442knocks
knoll9389602knoll
knolls10367412knolls
knop107116592kno_p
knosp11576822knosp
knosps12405012knosps
knotty13315222knotty
knout95018262knout
know116115842kno_w
known12568342known
knowns13426442knowns
knurs94511152knurs
koas85635092k_oas
kobs105831082k_obs
kois85129402k_ois
konks84917112konks
kooks85217262kooks
kops107031292k_ops
kors85933012k_ors
kos76944822k_o_s
koss85224812k_oss
koto86323472k_oto
kotos95717702k_otos
kyats125012442kyats
loots55431422loots
lots47652092_lots
moots75831662moots
mots66853162_mots
nets45941532_nets
nits45741642_nits
nobs66436902_nobs
nods55838222_nods
noes45845392_noes
nogs56534612_nogs
noms65636402_noms
nos38859322_no_s
not39474662_not_
nota46830772_nota
note46239962_note
notes55034582_notes
nous46136982_nous
nows75738232_nows
nowts86915862_nowts
nuts45032672_nuts
onos46229002ono_s
oots46446442_oots
phots105418502phots
pinots85920272pinots
plots75025672plots
pots66452362_pots
reknots1136782reknots
riots54922012riots
roots55933672roots
rots46454092_rots
ryots85313782ryots
scots74025912scots
shots84730852shots
slots54830532slots
snits54124832snits
snobs74716152snobs
snogs66017492snogs
snoots64216682snoots
snorts64116502snorts
snot44745452snot_
snouts64915872snouts
snows84719892snows
soots55536212soots
sots45552452_sots
spots74424112spots
stots54828552stots
swots85518432swots
toots55331872toots
tots46654122_tots
trots56629942trots
units54923432units
unknots1144302unknots
wonts87621542wonts
wots76342892_wots

Search took 3 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 Filter178691538000.360496363.9
2DLD Change Limit538001241.68631909.8
3Display Results1241240.0333757.6
 (SQL Overall)1786911242.07985950.5
 
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.