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

162 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
swankest1510593(None) 
swankiest16136201swankiest
blankest14439062blankest
crankest1438142crankest
dankest122611672_dankest
frankest1536962frankest
lankest112714112_lankest
rankest112713812_rankest
sanest64426692s_an_est
scantest101710182scantest
skankiest12145702skankiest
slackest14289392slackest
starkest1239722starkest
swanked15359542swanke_d
swanker14369482swanke_r
swanks134811562swank_s_
wackest164710862_wackest
waniest103819112_waniest
wannest103915002_wannest
anankes1138763anankes_
awakes135012473awa_kes_
blackest16269303blackest
blandest113811043blandest
blanket134313093blanke_t
blankets14356503blankets
clankiest1536663clankiest
crankiest1538823crankiest
darkest122512623_darkest
drunkest1334423drunkest
dwarfest1543473dwarfest
fawniest14287443fawniest
grandest10311573grandest
inanest72115363inan_est
lankiest122912493_lankiest
leanest7415863lean_est
meanest9315703mean_est
pinkest132812623_pinkest
punkest132611693_punkest
saddest92412383s_addest
safest95016603s_a_fest
sagest74920263s_a_gest
sagiest82617983s_agiest
sakes95540753s_a_kes_
saltest71916513s_altest
sandiest93218683s_andiest
sanes55649073s_an_es_
sanies63031953s_anies_
sarkiest123615063s_arkiest
sayest94217743s_a_yest
scaliest101714393scaliest
scandent1148493scandent
scantiest112611003scantiest
scarcest12169173scarcest
scariest101615943scariest
seamiest102715413seamiest
seances93015343seances_
searest73322023sea_rest
shadiest121711273shadiest
shakes135024593sha_kes_
shakiest151910933shakiest
shaliest111415053shaliest
shanked153212123shanke_d
shanks135315583shank_s_
sharpest1339143sharpest
shiniest113212493shiniest
sickest131813793s_ickest
skanked11338103skanke_d
skanker10268483skanke_r
skankers11316483skankers
skanks94710833skank_s_
skunkiest12135093skunkiest
slakes104021883sla_kes_
slangiest10129073slangiest
slatiest82616263slatiest
sleekest1236153sleekest
slickest14229253slickest
slinkiest13188073slinkiest
smallest1039403smallest
smartest10310183smartest
snakes103919603sna_kes_
snakiest122110543snakiest
snarkiest13207633snarkiest
soapiest102412843soapiest
soonest7415593soon_est
soundest9510973soundest
spaciest122310893spaciest
spanked143111733spanke_d
spanker133612353spanke_r
spankers14369863spankers
spanks124514123spank_s_
spanless10247363spanless
sparest94616423spa_rest
sparkiest15188093sparkiest
sparsest1048813sparsest
spiniest102813223spiniest
spunkiest15166563spunkiest
stablest103312943stablest
stagiest91613403stagiest
staidest939803staidest
stakes103927293sta_kes_
stalest73720173sta_lest
stalkiest1347903stalkiest
stances93715963stances_
stanchest14218213stanchest
stanes64933403stan_es_
stanks104917703stank_s_
stinkiest13198463stinkiest
stoniest8413543stoniest
strangest103210843strangest
suavest10310623sua_vest
sunket103721363s_unke_t
sunkets113511283s_unkets
sunniest82712913sunniest
swacked173110523swacke_d
swages104417073swa_ges_
swales93920763swa_les_
swamies123712063swamies_
swampiest1635023swampiest
swanherd1533483swanherd
swank125318233swank___
swankier15225503swankier
swankily1833833swankily
swankiness1744253swankiness
swanking16399963swanking
swanky16447973swank__y
swanned11358173swanne_d
swannery1433553swannery
swans84625013swan__s_
swashes134714403swashes_
swathes134115513swathes_
sweatiest1238413sweatiest
sweetest1137173sweetest
swellest1137663swellest
swiftest1434353swiftest
swinges113413423swinges_
swingiest13207573swingiest
swinked15349033swinke_d
swinks134610653swink_s_
swooniest12176293swooniest
tannest72617853_tannest
tawniest11279343tawniest
twangiest1355223twangiest
twankies1535893twankies_
twiniest1147153twiniest
wackes154717713_wackes_
wackiest172610273_wackiest
wakes126633653_wa_kes_
wanes85040883_wan_es_
wanked144517153_wanke_d
wanker134219973_wanke_r
wankers144514713_wankers
wanks126124483_wank_s_
wanness102610683_wanness
wariest105122503_wariest
warmest123113033_warmest
wattest102412153_wattest
waviest134513073_waviest
waxiest173510883_waxiest
weakest1439003_weakest
winiest103419693_winiest
wonkiest1538943_wonkiest
zaniest163214773_zaniest

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621627.61019206.6
3Display Results1621620.0632571.4
 (SQL Overall)1786911628.07922118.0
 
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.