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

142 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
snottiest916797(None) 
knottiest13174561knottiest
snootiest9178751snootiest
snoutiest9178251snoutiest
spottiest11177681spottiest
blottiest11286832blottiest
dottiest92611392_dottiest
gnattiest1035382gnattiest
grottiest10147182grottiest
nattiest83215352_nattiest
nettiest83112432_nettiest
nittiest82712602_nittiest
nuttiest82312142_nuttiest
plottiest11287832plottiest
pottiest102815972_pottiest
scattiest11268362scattiest
scotties1039752scotties_
shittiest1238332shittiest
slittiest938202slittiest
sluttiest937332sluttiest
smuttiest1135972smuttiest
snobbiest1354962snobbiest
snoopiest11157062snoopiest
snooziest18175392snooziest
snottier8217382snottie_r
snottiness1055592snottiness
snowiest1138142sno_wiest
sootiest84016752s_ootiest
sportiest111711022sportiest
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
knobbiest1752883knobbiest
knottier12203983knottie_r
knottiness1483593knottiness
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
saltiest83117713s_altiest
scantiest112611003scantiest
scottie937463scottie__
shiftiest1537363shiftiest
shirtiest1239323shirtiest
shoaliest1238503shoaliest
shoddiest1434753shoddiest
shortest11310783short_est
shorties11414583shorties_
showiest1438783sho_wiest
siltiest83515613s_iltiest
slatiest82616263s_latiest
sleetiest938553sleetiest
slobbiest1345083slobbiest
sloppiest1345973sloppiest
sloshiest1246673sloshiest
smoggiest1334463smoggiest
smokiest1437883smo_kiest
smoothest14215773smoothest
snaggiest11126673snaggiest
snakiest122110543sn_akiest
snappiest1346493snappiest
snarkiest13207633snarkiest
snarliest91810203snarliest
snatchiest1545153snatchiest
snazziest1743133snazziest
sneakiest13176833sneakiest
sneeriest939313sneeriest
sneeziest1845153sneeziest
sniffiest15236003sniffiest
snippiest1345723snippiest
snootier8278383snootie_r
snootiness1085833snootiness
snottily1145553snotti_ly
snoutier8206973snoutie_r
snoutish1145783snouti_sh
snubbiest1345073snubbiest
snuffiest15246053snuffiest
soapiest102412843s_oapiest
softest10310603s_oft_est
softies103414613s_ofties_
soggiest102711643s_oggiest
sonsiest8313033s_onsiest
soothest113312243s_oothest
soppiest122511933s_oppiest
sorriest8413883s_orriest
sorties74126403s_orties_
sottish10129443s_otti_sh
soupiest102212913s_oupiest
spongiest1237083spongiest
spookiest15156393spookiest
spooniest11178133spooniest
spottier10207313spottie_r
spottiness1285763spottiness
squattiest1944233squattiest
stockiest15207753stockiest
stodgiest1135653stodgiest
stoniest8413543sto_niest
stormiest1137003stormiest
stoutest837613stout_est
sultriest938653sultriest
sweatiest1238413sweatiest
swooniest12176293swooniest
swoopiest14155383swoopiest
tattiest83415383_tattiest
toothiest1237523toothiest
troutiest9127803troutiest
wittiest112711523_wittiest
zootiest173311213_zootiest

Search took 8 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.423422437.4
2DLD Change Limit1486411427.01621186.0
3Display Results1421420.0602366.7
 (SQL Overall)1786911427.49923828.6
 
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.