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

264 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
swankier1522550(None) 
skankier11184881skankier
swanker14369481swank_er
clankier14327082clankier
crankier14339162crankier
lankier113711632_lankier
sandier84017842s_andier
sarkier113413312s_arkier
scantier10309982scantier
shakier143411152sha_kier
skanker10268482skank_er
skunkier11174282skunkier
slangier9117932slangier
slinkier12206932slinkier
snakier112810002sna_kier
snarkier12336512snarkier
spanker133612352spank_er
sparkier14298032sparkier
spunkier14235822spunkier
stalkier1257072stalkier
stinkier12278542stinkier
swampier1544592swampier
swanked15359542swank_ed
swankiest16136202swankiest
swankily1833832swankily
swanking16399962swanking
swingier12267002swingier
twangier1254242twangier
twankies1535892twankies
wackier16369732_wackier
wanier93920682_wan_ier
wanker134219972_wank_er
wonkier1437422_wonkier
balkier134111983_balkier
banker124222733_bank_er
barkier133814483_barkier
beakier134012163bea_kier
blanker134612023blank_er
brakier133812363bra_kier
brannier10218933brannier
cakier123115243_ca_kier
canker124422523_cank_er
cannier94014163_cannier
chalkier1736753chalkier
chancier1538823chancier
chinkier17377363chinkier
chunkier17395883chunkier
clunkier14345793clunkier
cranker133612793crank_er
dandier93714573_dandier
danker114319663_dank_er
dinkier123411503_dinkier
fancier123412063_fancier
fawnier13296363fawn_ier
flakier143910203fla_kier
flanker143911293flank_er
franker143510183frank_er
funkier14349983_funkier
gawkier15326523_gawkier
gunkier12369553_gunkier
handier113817443_handier
hanker134622093_hank_er
hankie133915713_hankie_
hankies143617763_hankies
hinkier143610793_hinkier
hunkier144512143_hunkier
inkier104013783__inkier
junkier18339493_junkier
kinkier10319433_kinkier
lakier104716273_la_kier
lanker104123003_lank_er
larkier113711523_larkier
leakier114010993lea_kier
mangier104114063_mangier
manlier92414023_manlier
oakier104011393_oa_kier
orangier947713orangier
panier84425503_pan_ier
pannier93613353_pannier
pawkier16236613_pawkier
peakier134411443pea_kier
plankter1435363plankter
plunkier14305323plunkier
punkier133512793_punkier
quackier23215373quackier
quakier20239203qua_kier
randier83618473_randier
rangier83714353_rangier
ranker105021903_rank_er
sacker125124843s_ack_er
saggier92912063s_aggier
sagier73717163s_a_gier
saker95132023s_a_k_er
sallier73320423s_allier
saltier74318633s_altier
sander74828533s_an_der
saner54334323s_an__er
sanger74524563s_an_ger
sanies63031953s_an_ies
santir6315253s_anti_r
sappier113613113s_appier
sassier73413233s_assier
saucier9810283s_aucier
savvier1335483s_avvier
scabbier1435133scabbier
scalier94316913sca_lier
scanner94411813scan_ner
scanter94215183scan_ter
scanties103215423scanties
scarier94017873sca_rier
scarrier10298453scarrier
scattier10267583scattier
seamier93114633sea_mier
shabbier1535183shabbier
shackler17317973shackler
shadier113111153sha_dier
shaggier13116053shaggier
shaker134319463sha_k_er
shalier103116423sha_lier
shandies122714103shandies
shanked153212123shank_ed
shanking163612283shanking
shannies113411253shannies
shanties113116583shanties
sharker144313813shark_er
shinier104113143shin_ier
silkier114411643s_ilkier
sinker103620903s_ink_er
skanked11338103skank_ed
skankers11316483skank_ers
skankiest12145703skankiest
skanking12288743skanking
skier95119593s___kier
skinker10319443skink_er
skinnier1264893skinnier
slacker133915293slack_er
slaggier10126953slaggier
slaker104219273sla_k_er
slander84015443slan_der
slatier74016813sla_tier
sleekier1245573sleekier
smacker153410583smack_er
smarmier1235033smarmier
smirkier1444433smirkier
smokier1356703s_mokier
snacker133112603snack_er
snaggier10136303snaggier
snappier1266213snappier
snarlier8278183snarlier
snazzier1642483snazzier
sneakier1245143sneakier
soaker105717533soa_k_er
soapier93411713soa_pier
sonsier7711743s_onsier
spacier114011633spa_cier
spanglier1244193spanglier
spaniel948923span_iel
spanked143111733spank_ed
spankers14369863spank_ers
spanking153911973spanking
spanner94312563span_ner
sparker133914363spark_er
sparkler14317983sparkler
sparklier1554363sparklier
sparrier10329143sparrier
spendier1147143spendier
spikier13369983s_pikier
spinier93715163spin_ier
spongier1135743spongier
spookier14175493spookier
spunkie13215303spunkie_
spunkies14227593spunkies
stacker134416263stack_er
staggier10167513staggier
stagier83513443sta_gier
stalker113912253stalk_er
stancher13198813stancher
stander84316163stan_der
starker114114693stark_er
starrier8279463starrier
stickier14229763stickier
stingier9279123stingier
stinker113313313stink_er
stockier14217253stockier
stonier72013793ston_ier
suckier133613973s_uckier
sulkier113811963s_ulkier
sunnier73412153s_unnier
swabber14297963swa_bber
swabbie1484333swabbie_
swabbies15115713swabbies
swacked173110523swack_ed
swager104013613swa__ger
swagger12389333swa_gger
swaggie12135783swaggie_
swaggies13136693swaggies
swamies123712063swa_mies
swamper14349313swa_mper
swanherd1533483swan_herd
swank125318233swank___
swankest15105933swankest
swankiness1744253swankiness
swanks134811563swank__s
swanky16447973swank__y
swanlike1535313swanlike
swanned11358173swan_ned
swannery1433553swan_nery
swanning12338813swanning
swanskin1543533swanski_n
swanskins1643283swanskins
swapper14359703swa_pper
swarmer1247803swa_rmer
swarthier1543783swarthier
swasher134011513swa_sher
swather134213603swa_ther
swatter104113323swa_tter
swayer125210973swa__yer
sweatier1147033sweatier
sweepier1355493sweepier
swimmier15174313swimmier
swindler12257723swindler
swinger113812563swin_ger
swinked15349033swink_ed
swinking163410323swinking
swirlier1135213swirlier
swishier1434563swishier
swoonier11185133swoonier
swoopier13175143swoopier
tackier133712523_tackier
talkier114011843_talkier
tangier83013903_tangier
tanker104521123_tank_er
tawnier10318463tawn_ier
thanker14309593thank_er
twanger11327433twan_ger
twangler1244113twangler
tweakier1533143tweakier
twinier1037313twin_ier
twinkie1434573twinkie_
twinkies1535983twinkies
twinkler1564073twinkler
wacker154920123_wack_er
waker125526593_wa_k_er
walker133913993_walk_er
wander104423713_wan_der
wangler113312653_wangler
wanked144517153_wank_ed
wankers144514713_wank_ers
wanking154216783_wanking
wanner94019623_wan_ner
wanter94423053_wan_ter
warier93722893_wa_rier
wartier103413913_wartier
washier133611153_washier
waspier12259053_waspier
wavier124613083_wa_vier
waxier16439903_wa_xier
wennier10318603_wennier
whackier2044673whackier
windier113412163_windier
wingier113413283_wingier
winier94522453_win_ier
winker134220293_wink_er
zanier154314713_zan_ier

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.406440125.6
2DLD Change Limit1461622646.36022981.4
3Display Results2642640.0932838.7
 (SQL Overall)1786912646.85926052.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.