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

193 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
swoopier1317514(None) 
snoopier10177271snoopier
swoonier11185131swoonier
swooper12389171swoop_er
droopier1145572droopier
goopier103910572_goopier
loopier93711192_loopier
scooper113812032scoop_er
sloppier1255702sloppier
snooper93511532snoop_er
snootier8278382snootier
snoozier17185192snoozier
soapier93411712s_oapier
sootier73916612s_ootier
soppier112711582s_oppier
soupier93111752s_oupier
spookier14175492spookier
spoonier10167652spoonier
stooper93813192stoop_er
swampier1544592swampier
sweepier1355492sweepier
swooner10358672swoo_ner
swooped13418752swoop_ed
swoopers13317522swoop_ers
swoopiest14155382swoopiest
swooping14338402swooping
woodier113912062_woodier
woolier103612352_woolier
woozier19347322_woozier
bloodier1136823bloodier
bloomier1275783bloomier
blooper11358533bloop_er
boomier113312183_boomier
boozier18349013_boozier
broodier1157433broodier
broomier1236873broomier
choosier1337173choosier
choppier17286643choppier
cooper104221123_coop_er
copier103722893__copier
croupier1246883croupier
doomier103610123_doomier
dopier93515923__dopier
droolier936073droolier
floppier1554633floppier
footier104115113_footier
gloomier1135093gloomier
gloppier1354673gloppier
goofier11339313_goofier
gooier73516213_goo_ier
goonier83612843_goonier
goosier83512563_goosier
groovier1233793groovier
hoodier113812973_hoodier
hookier143811673_hookier
hooper114518313_hoop_er
hootier104915353_hootier
hoppier143110703_hoppier
kookier10398283_kookier
loonier73312683_loonier
looper83817113_loop_er
loppier11369723_loppier
moodier103212203_moodier
moonier93714103_moonier
moorier93113073_moorier
mopier103914783__mopier
oozier153610253__oozier
rookier114012383_rookier
roomier93812243_roomier
rootier74915393_rootier
ropier84118803__ropier
roupier9319493_roupier
sappier113613113s_appier
savorier1136643savorier
scooped124611743scoop_ed
scoopers124210193scoop_ers
scooping133610633scooping
scooter93312873scoo_ter
seepier92912013s_eepier
shoalier1137073shoalier
shoddier1334213shoddier
shooter103013993shoo_ter
shopper143312633s_hopper
showier1339103s_howier
sinopie948783sinopie_
sirupier1034303sirupier
skimpier1634293skimpier
sleepier1036783sleepier
slippier1256533slippier
slobbier1254633slobbier
sloper84615913s_lop_er
sloshier1135283sloshier
smoggier1243973smoggier
smokier1356703s_mokier
smoocher15205503smoocher
smoother13196673smoother
snappier1266213snappier
snippier1255793snippier
snobbier1234633snobbier
snooker113910303snoo_ker
snooped103711813snoop_ed
snoopers10319843snoop_ers
snoopiest11157063snoopiest
snoopily1345553snoopily
snooping113811323snooping
snoozer16409193snoo_zer
snottier8217383snottier
snoutier8206973snoutier
snowier1038793s_nowier
soaper84517873s_oap_er
soggier93410883s_oggier
soldier82812153s_oldier
sonsier7711743s_onsier
sooner64220463s_oo_ner
soother104215043s_oother
sorrier72313733s_orrier
spier75728033s___pier
spongier1135743spongier
spoofer12368723spoo_fer
spooler93711383spoo_ler
spoonies101911753spoonies
sportier102010053sportier
spottier10207313spottier
stockier14217253stockier
stodgier1034223stodgier
stomper114111233stomp_er
stonier72013793s_tonier
stooker113811733stoo_ker
stoolie739723stoolie_
stoolies8311083stoolies
stooped103813833stoop_ed
stoopers103711303stoop_ers
stooping113012363stooping
stoper84320103s_top_er
stopover1344063stopover
stopper113012603s_topper
stormier1036103stormier
stripier1058863stripier
stropper1247763stropper
stroppier1364453stroppier
stumpier1255883stumpier
swamper14349313swamp_er
swankier15225503swankier
swapper14359703sw_apper
sweatier1147033sweatier
sweeper12329373sweep_er
swimmier15174313swimmier
swingier12267003swingier
swirlier1135213swirlier
swishier1434563swishier
swobber14336543sw_obber
swooned11368593swoo_ned
swooners11336863swoo_ners
swooniest12176293swooniest
swooning12278203swooning
swoop105213433swoop___
swoops114910923swoop__s
swoopy14487283swoop__y
swooshed15174273swooshed
swooshes14185123swooshes
swopped15437673sw_opped
swopping16377963swopping
swotter10399473sw_otter
syrupier1343053syrupier
trooper94210363troop_er
twoonie1034423twoonie_
twoonies1155693twoonies
waspier12259053_waspier
weepier12319273_weepier
whooper15297153whoop_er
whoopie15295933whoopie_
whoopies16267373whoopies
whopper17328503_whopper
wimpier14248053_wimpier
wispier12249403_wispier
wombier1436543_wombier
wonkier1437423_wonkier
woodie103513613_woodie_
woodies113517153_woodies
woodsier1245473_woodsier
wooer84316693_woo__er
woofer124411363_woo_fer
wooler93615873_woo_ler
woolie93514483_woolie_
woolies104117363_woolies
woollier1155433_woollier
woopsed1344733_woopsed
woopses1237883_woopses
wordier112511213_wordier
wormier12278763_wormier
worrier102311683_worrier
zooier153411233_zoo_ier
zootier163611173_zootier

Search took 7 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621936.17323677.6
3Display Results1931930.0603216.7
 (SQL Overall)1786911936.65626846.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.