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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
knottiest1317456(None) 
snottiest9167971snottiest
blottiest11286832blottiest
dottiest92611392_dottiest
gnattiest1035382gnattiest
grottiest10147182grottiest
knobbiest1752882knobbiest
knottier12203982knottie_r
knottiness1483592knottiness
nattiest83215352_nattiest
nettiest83112432_nettiest
nittiest82712602_nittiest
nuttiest82312142_nuttiest
plottiest11287832plottiest
pottiest102815972_pottiest
snootiest9178752snootiest
snoutiest9178252snoutiest
spottiest11177682spottiest
antsiest8511463an_tsiest
battiest104115553_battiest
bittiest103012043_bittiest
brattiest1148103brattiest
cattiest103016333_cattiest
chattiest1448203chattiest
dotiest83717453_do_tiest
fattiest113514313_fattiest
floatiest1237283floatiest
footiest113514913_footiest
frettiest1267063frettiest
frostiest1239213frostiest
frothiest1537453frothiest
ghostiest1336543ghostiest
goutiest93013883_goutiest
grittiest10176983grittiest
groutiest10147763groutiest
guttiest92311223_guttiest
hootiest113115643_hootiest
hottest10411383_hott_est
hotties103016963_hotties_
jettiest15359593_jettiest
joltiest15249403_joltiest
kitties113213623k_itties_
kittlest12297573k_ittlest
klutziest2242803klutziest
knobbliest1852163knobbliest
knotless1264573kno_tless
knotted12357233knott_e_d
knotter11317643knott_e_r
knotters12276153knott_ers
knottily1543153knotti_ly
knotting13236573knotti_ng
knottings14243073knottings
knubbiest1752623knubbiest
knurliest1344073knurliest
kookiest11268133k_ookiest
loftiest1139083_loftiest
mothiest13311033_mothiest
motliest10310773_motliest
nastiest83615953_nastiest
nettliest945413_nettliest
niftiest112910073_niftiest
nobbiest12117773_nobbiest
noisiest839763_noisiest
nosiest73415673_no_siest
nutsiest82710243_nutsiest
pettiest103113963_pettiest
plotties103111413plotties_
potties93723543_potties_
poutiest103016793_poutiest
prettiest1199803prettiest
rattiest83516113_rattiest
rootiest83115593_rootiest
ruttiest82712663_ruttiest
scattiest11268363scattiest
scotties1039753scotties_
shittiest1238333shittiest
slittiest938203slittiest
sluttiest937333sluttiest
smuttiest1135973smuttiest
snobbiest1354963snobbiest
snoopiest11157063snoopiest
snooziest18175393snooziest
snottier8217383snottie_r
snottiness1055593snottiness
snowiest1138143sno_wiest
sootiest84016753_sootiest
sportiest111711023sportiest
tattiest83415383_tattiest
toothiest1237523toothiest
troutiest9127803troutiest
wittiest112711523_wittiest
zootiest173311213_zootiest

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 Filter1786911486410.420425454.8
2DLD Change Limit148641926.26623721.8
3Display Results92920.0303066.7
 (SQL Overall)178691926.71626606.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.