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
swoopiest1415539(None) 
snoopiest11157071snoopiest
swooniest12176291swooniest
droopiest1235742droopiest
goopiest112710552_goopiest
loopiest103011322_loopiest
sloppiest1345982sloppiest
snootiest9178752snootiest
snooziest18175392snooziest
soapiest102412852s_oapiest
sootiest84016752s_ootiest
soppiest122511942s_oppiest
soupiest102212922s_oupiest
spookiest15156402spookiest
spooniest11178142spooniest
swampiest1635032swampiest
sweepiest1435682sweepiest
swoopier13175142swoopie_r
woodiest123112072_woodiest
wooliest113011642_wooliest
wooziest20327902_wooziest
bloodiest1236663bloodiest
bloomiest1335853bloomiest
boomiest122711843_boomiest
booziest19379263_booziest
broodiest1237823broodiest
broomiest1356913broomiest
choosiest1437323choosiest
choppiest18226383choppiest
croupiest1337063croupiest
doomiest112910453_doomiest
dopiest103315993__dopiest
drooliest1036343drooliest
floppiest1654783floppiest
footiest113514913_footiest
gloomiest1235603gloomiest
gloppiest1444833gloppiest
goofiest12289393_goofiest
gooiest82813883_goo_iest
gooniest93213003_gooniest
goosiest92911823_goosiest
grooviest1334083grooviest
hoodiest122413173_hoodiest
hookiest152712103_hookiest
hootiest113115643_hootiest
hoppiest152610733_hoppiest
kookiest11268133_kookiest
looniest83313253_looniest
loppiest122410113_loppiest
moodiest112712183_moodiest
mooniest103014173_mooniest
mooriest102812723_mooriest
mopiest113014293__mopiest
ooziest163411523__ooziest
rookiest122912173_rookiest
roomiest102611993_roomiest
rootiest83115593_rootiest
ropiest93317773__ropiest
roupiest102610293_roupiest
sappiest122612583s_appiest
savoriest1246623savoriest
seepiest102412633s_eepiest
shoaliest1238513shoaliest
shoddiest1434763shoddiest
showiest1438793s_howiest
sirupiest1154763sirupiest
skimpiest1734513skimpiest
sleepiest1136723sleepiest
slippiest1346473slippiest
slobbiest1345093slobbiest
sloshiest1246683sloshiest
smoggiest1334463smoggiest
smokiest1437883s_mokiest
smoothest14215773smoothest
snappiest1346503snappiest
snippiest1345733snippiest
snobbiest1354963snobbiest
snoopier10177273snoopie_r
snottiest9167973snottiest
snoutiest9178253snoutiest
snowiest1138143s_nowiest
soggiest102711643s_oggiest
sonsiest8313033s_onsiest
soonest7415593s_oo_nest
soothest113312243s_oothest
sorriest8413883s_orriest
spongiest1237093spongiest
spoonies101911753spoonies_
sportiest111711033sportiest
spottiest11177693spottiest
stockiest15207753stockiest
stodgiest1135653stodgiest
stoniest8413543s_toniest
stoolies8311083stoolies_
stormiest1137003stormiest
stripiest1138023stripiest
stroppiest1444573stroppiest
stumpiest1335863stumpiest
swankiest16136213swankiest
sweatiest1238423sweatiest
swimmiest1634253swimmiest
swingiest13207573swingiest
swirliest1236293swirliest
swishiest1535523swishiest
swoonier11185133swoonie_r
swooped13418753swoop_e_d
swooper12389173swoop_e_r
swoopers13317523swoop_ers
swooping14338403swoopi_ng
swoops114910923swoop__s_
swooshes14185123swooshes_
syrupiest1453233syrupiest
twoonies1155693twoonies_
waspiest1338823_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.12620859.0
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.60823487.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.