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

165 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
spottiest1117769(None) 
pottiest102815971_pottiest
snottiest9167971snottiest
sportiest111711031sportiest
blottiest11286832blottiest
dottiest92611392_dottiest
grottiest10147182grottiest
knottiest13174562knottiest
pettiest103113962_pettiest
plottiest11287832plottiest
potties93723542_potties_
poutiest103016792_poutiest
scattiest11268372scattiest
scotties1039752scotties_
shittiest1238342shittiest
slittiest938212slittiest
sluttiest937342sluttiest
smuttiest1135972smuttiest
snootiest9178752snootiest
snoutiest9178252snoutiest
sootiest84016752s_ootiest
spongiest1237092spongiest
spookiest15156402spookiest
spooniest11178142spooniest
spottier10207312spottie_r
spottiness1285762spottiness
battiest104115553_battiest
bittiest103012043_bittiest
brattiest1148103brattiest
cattiest103016333_cattiest
chattiest1448213chattiest
dotiest83717453_do_tiest
fattiest113514313_fattiest
floatiest1237293floatiest
footiest113514913_footiest
frettiest1267063frettiest
frostiest1239213frostiest
frothiest1537453frothiest
ghostiest1336543ghostiest
gnattiest1035383gnattiest
goutiest93013883_goutiest
grittiest10176983grittiest
groutiest10147763groutiest
guttiest92311223_guttiest
hootiest113115643_hootiest
hottest10411383_hott_est
hotties103016963_hotties_
jettiest15359593_jettiest
joltiest15249403_joltiest
loftiest1139083_loftiest
mothiest13311033_mothiest
motliest10310773_motliest
nattiest83215353_nattiest
nettiest83112433_nettiest
nittiest82712603_nittiest
nuttiest82312143_nuttiest
pastiest103319553_pastiest
patties93425143_patties_
peatiest103118813_peatiest
pestiest103018413_pestiest
pithiest132711443_pithiest
platiest103216093_platiest
plotties103111413plotties_
pockiest163412053_pockiest
podgiest12269093_podgiest
pointiest1139623_pointiest
pokiest133314913_po_kiest
politest10312943_politest
porkiest143513713_porkiest
porniest103214313_porniest
portliest11310183_portliest
posties93128813_posties_
posttest10410233_posttest
potpies113116173_potpies_
potsies93019483_potsies_
pottier93516493_pottie_r
pottiness1179703_pottiness
pottles93816983_pottles_
poxiest163412253_po_xiest
prettiest1199803prettiest
purtiest102414113_purtiest
putties94420023_putties_
rattiest83516113_rattiest
rootiest83115593_rootiest
ruttiest82712663_ruttiest
saltiest83117723s_altiest
scantiest112611013scantiest
scottie937463scottie__
shiftiest1537373shiftiest
shirtiest1239333shirtiest
shoaliest1238513shoaliest
shoddiest1434763shoddiest
shortest11310783short_est
shorties11414583shorties_
showiest1438793sho_wiest
siltiest83515613s_iltiest
slatiest82616273s_latiest
sleetiest938563sleetiest
slobbiest1345093slobbiest
sloppiest1345983sloppiest
sloshiest1246683sloshiest
smoggiest1334463smoggiest
smokiest1437883smo_kiest
smoothest14215773smoothest
snobbiest1354963snobbiest
snoopiest11157073snoopiest
snooziest18175393snooziest
snottier8217383snottie_r
snottiness1055593snottiness
snowiest1138143sno_wiest
soapiest102412853s_oapiest
softest10310603s_oft_est
softies103414613s_ofties_
soggiest102711643s_oggiest
sonsiest8313033s_onsiest
soothest113312243s_oothest
soppiest122511943s_oppiest
sorriest8413883s_orriest
sorties74126403s_orties_
sottish10129443s_otti_sh
soupiest102212923s_oupiest
spaciest122310903sp_aciest
sparkiest15188103sparkiest
sparriest11198793sparriest
speediest1257473speediest
spendiest1237533spendiest
spheriest1438383spheriest
spiciest122711613sp_iciest
spiffiest17235663spiffiest
spikiest14259543sp_ikiest
spiniest102813233sp_iniest
spiriest102513463sp_iriest
spittles1038333spittles_
splotchiest1852083splotchiest
spoonies101911753spoonies_
sportier102010053sportie_r
sportiness1278233sportiness
spotless1037043spo_tless
spotlight1543713spotlight
spotlit947303spotli__t
spotted103713143spott_e_d
spotter94514883spott_e_r
spotters104313383spott_ers
spottily1335153spotti_ly
spotting112812093spotti_ng
spoutless1134243spoutless
spriest92718653sp__riest
spruciest1345153spruciest
spumiest1238213sp_umiest
spunkiest15166573spunkiest
squattiest1944243squattiest
stockiest15207753stockiest
stodgiest1135653stodgiest
stoniest8413543sto_niest
stormiest1137003stormiest
stoutest837613stout_est
sultriest938653sultriest
sweatiest1238423sweatiest
swooniest12176293swooniest
swoopiest14155393swoopiest
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 Limit1486411656.73622066.7
3Display Results1651650.0762171.1
 (SQL Overall)1786911657.23524698.1
 
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.