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

148 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
blottiest1128683(None) 
plottiest11287831plottiest
battiest104115552b_attiest
bittiest103012042b_ittiest
blastiest111710052blastiest
blockiest1736362blockiest
bloodiest1236662bloodiest
bloomiest1335852bloomiest
blotchiest1743522blotchiest
blottier10336412blottie_r
blousiest1136312blousiest
blowiest1337922blo_wiest
blowsiest1435322blowsiest
blowziest2343672blowziest
brattiest1148102brattiest
dottiest92611392_dottiest
floatiest1237292floatiest
grottiest10147182grottiest
knottiest13174562knottiest
loftiest1139082_loftiest
plotties103111412plotties_
pottiest102815972_pottiest
slittiest938212slittiest
sluttiest937342sluttiest
snottiest9167972snottiest
spottiest11177692spottiest
biotites10310083biotites_
bitsiest102610063b_itsiest
blasties102113633blasties_
bleariest1158853bleariest
blithest1338083bl_ithest
blondest11419243blo_ndest
bloodies11310163bloodies_
blotches1537433blotches_
blotless10347153blo_tless
blotted103911833blott_e_d
blotter94612853blott_e_r
blotters104110983blott_ers
blotting113910433blotti_ng
bluesiest1135693bluesiest
bluntest1036553blunt_est
blurriest1155153blurriest
boggiest123110933b_oggiest
boniest93318993b_o_niest
bonniest10310773b_onniest
boomiest122711843b_oomiest
booties94124613b_ooties_
booziest19379263b_ooziest
boskiest14289733b_oskiest
bossiest103112213b_ossiest
botchiest1636153b_otchiest
bothies12414783b_othies_
bottles94216273b_ottles_
boxiest163711983b_o_xiest
brittlest11146193brittlest
bronziest2035813bronziest
broodiest1237823broodiest
broomiest1356913broomiest
browniest14207123browniest
bustiest102815053b_ustiest
butties93217953b_utties_
cattiest103016333_cattiest
chattiest1448213chattiest
cloddiest1334633cloddiest
cloggiest1334723cloggiest
cloudiest1235583cloudiest
dotiest83717453_do_tiest
fattiest113514313_fattiest
flattest1138713flatt_est
flintiest1248433flintiest
flirtiest1236193flirtiest
flockiest1835643flockiest
floppiest1654783floppiest
flossiest12296803flossiest
flutiest112610883fl_utiest
footiest113514913_footiest
frettiest1267063frettiest
frostiest1239213frostiest
frothiest1537453frothiest
ghostiest1336543ghostiest
gleetiest1035913gleetiest
glintiest1037623glintiest
glitziest1944003glitziest
globbiest1444023globbiest
gloomiest1235603gloomiest
gloppiest1444833gloppiest
glossiest10277943glossiest
glottides1163833glottides_
glottis837173glotti_s_
glottises1084953glottises
gnattiest1035383gnattiest
goutiest93013883_goutiest
grittiest10176983grittiest
groutiest10147763groutiest
guttiest92311223_guttiest
hootiest113115643_hootiest
hottest10411383_hott_est
hotties103016963_hotties_
jettiest15359593_jettiest
joltiest15249403_joltiest
klutziest2242803klutziest
lathiest11312663_lathiest
lintiest82715913_lintiest
littlest8309243_littlest
loamiest102310213_loamiest
loggiest103011013_loggiest
logiest82515543_lo_giest
looniest83313253_looniest
loopiest103011323_loopiest
loppiest122410113_loppiest
lottes65322753_lott_es_
lousiest82311613_lousiest
lowliest11229473_lowliest
lustiest82914493_lustiest
mothiest13311033_mothiest
motliest10310773_motliest
nattiest83215353_nattiest
nettiest83112433_nettiest
nittiest82712603_nittiest
nuttiest82312143_nuttiest
pettiest103113963_pettiest
platiest103216093pl_atiest
plottier10327263plottie_r
potties93723543_potties_
poutiest103016793_poutiest
prettiest1199803prettiest
rattiest83516113_rattiest
rootiest83115593_rootiest
ruttiest82712663_ruttiest
scattiest11268373scattiest
scotties1039753scotties_
shittiest1238343shittiest
slatiest82616273sl_atiest
sleetiest938563sleetiest
slobbiest1345093slobbiest
sloppiest1345983sloppiest
sloshiest1246683sloshiest
smuttiest1135973smuttiest
snootiest9178753snootiest
snoutiest9178253snoutiest
sootiest84016753_sootiest
sportiest111711033sportiest
tattiest83415383_tattiest
toothiest1237523toothiest
troutiest9127803troutiest
wittiest112711523_wittiest
zloties1639913zlo_ties_
zootiest173311213_zootiest

Search took 9 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.860207780.2
2DLD Change Limit1486411487.75019179.5
3Display Results1481480.0602466.7
 (SQL Overall)1786911488.67020610.3
 
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.