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

129 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
swoopiest1415538(None) 
snoopiest11157061snoopiest
swooniest12176291swooniest
droopiest1235742droopiest
goopiest112710552_goopiest
loopiest103011312_loopiest
sloppiest1345972sloppiest
snootiest9178752snootiest
snooziest18175392snooziest
soapiest102412842s_oapiest
sootiest84016752s_ootiest
soppiest122511932s_oppiest
soupiest102212912s_oupiest
spookiest15156392spookiest
spooniest11178132spooniest
swampiest1635022swampiest
sweepiest1435672sweepiest
swoopier13175142swoopie_r
woodiest123112072_woodiest
wooliest113011642_wooliest
wooziest20327902_wooziest
bloodiest1236663bloodiest
bloomiest1335853bloomiest
boomiest122711843_boomiest
booziest19379263_booziest
broodiest1237823broodiest
broomiest1356913broomiest
choosiest1437323choosiest
choppiest18226373choppiest
croupiest1337063croupiest
doomiest112910453_doomiest
dopiest103315993__dopiest
drooliest1036343drooliest
floppiest1654773floppiest
footiest113514913_footiest
gloomiest1235603gloomiest
gloppiest1444823gloppiest
goofiest12289393_goofiest
gooiest82813883_goo_iest
gooniest93213003_gooniest
goosiest92911823_goosiest
grooviest1334083grooviest
hoodiest122413173_hoodiest
hookiest152712103_hookiest
hootiest113115643_hootiest
hoppiest152610723_hoppiest
kookiest11268133_kookiest
looniest83313253_looniest
loppiest122410103_loppiest
moodiest112712183_moodiest
mooniest103014173_mooniest
mooriest102812723_mooriest
mopiest113014293__mopiest
ooziest163411523__ooziest
rookiest122912173_rookiest
roomiest102611993_roomiest
rootiest83115593_rootiest
ropiest93317773__ropiest
roupiest102610293_roupiest
sappiest122612573s_appiest
savoriest1246613savoriest
seepiest102412623s_eepiest
shoaliest1238503shoaliest
shoddiest1434753shoddiest
showiest1438783s_howiest
sirupiest1154753sirupiest
skimpiest1734503skimpiest
sleepiest1136713sleepiest
slippiest1346463slippiest
slobbiest1345083slobbiest
sloshiest1246673sloshiest
smoggiest1334463smoggiest
smokiest1437883s_mokiest
smoothest14215773smoothest
snappiest1346493snappiest
snippiest1345723snippiest
snobbiest1354963snobbiest
snoopier10177273snoopie_r
snottiest9167973snottiest
snoutiest9178253snoutiest
snowiest1138143s_nowiest
soggiest102711643s_oggiest
sonsiest8313033s_onsiest
soonest7415593s_oo_nest
soothest113312243s_oothest
sorriest8413883s_orriest
spongiest1237083spongiest
spoonies101911753spoonies_
sportiest111711023sportiest
spottiest11177683spottiest
stockiest15207753stockiest
stodgiest1135653stodgiest
stoniest8413543s_toniest
stoolies8311083stoolies_
stormiest1137003stormiest
stripiest1138013stripiest
stroppiest1444563stroppiest
stumpiest1335853stumpiest
swankiest16136203swankiest
sweatiest1238413sweatiest
swimmiest1634253swimmiest
swingiest13207573swingiest
swirliest1236293swirliest
swishiest1535513swishiest
swoonier11185133swoonie_r
swooped13418753swoop_e_d
swooper12389173swoop_e_r
swoopers13317523swoop_ers
swooping14338403swoopi_ng
swoops114910923swoop__s_
swooshes14185123swooshes_
syrupiest1453223syrupiest
twoonies1155693twoonies_
waspiest1338813_waspiest
weepiest13219473_weepiest
whoopies16267373whoopies_
wimpiest1538763_wimpiest
wispiest1339513_wispiest
wombiest1536893_wombiest
wonkiest1538943_wonkiest
woodies113517153_woodies_
woodsiest1335203_woodsiest
woolies104117363_woolies_
woolliest1235853_woolliest
woopses1237883_woopses_
wordiest122311543_wordiest
wormiest13249543_wormiest
zooiest16199923_zoo_iest
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.436409841.7
2DLD Change Limit1486411297.39020113.8
3Display Results1291290.0632047.6
 (SQL Overall)1786911297.88922650.7
 
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.