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

248 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
staggies10121032(None) 
staggie9138461staggie_
staggier10167511staggier
staggiest11148261staggiest
swaggies13136691swaggies
aggies83515512__aggies
baggies113814852_baggies
jaggies163311082_jaggies
otalgies936392otalgies
raggies93214732_raggies
saggier92912062s_aggier
saggiest102812722s_aggiest
shaggier13116052shaggier
shaggiest14156902shaggiest
slaggier10126952slaggier
slaggiest11157712slaggiest
snaggier10136302snaggier
snaggiest11126682snaggiest
snuggies10246362snuggies
stages75629492sta_g_es
stagged104212082stagg_ed
stagger94212392stagg_er
staggers10379842staggers
stagging113310512stagging
stagier83513442sta_gier
stagiest91613412sta_giest
stogies8413692st_ogies
straggles11328502straggles
swaggie12135782swaggie_
aggie73415013__aggie_
anagogies11156163anagogies
ataxies142410013ata_xies
baggie102912193_baggie_
baggier113611643_baggier
baggiest123011753_baggiest
biggies113813523_biggies
braggier12136453braggier
braggiest13116783braggiest
buggies114613813_buggies
craggier12116063craggier
craggiest13116523craggiest
daggles103611913_daggles
doggies103613023_doggies
draggier11135773draggier
draggiest12126413draggiest
draggles1145963draggles
druggies11126223druggies
etageres936863etageres
faggier12309843_faggier
faggiest132910183_faggiest
flaggier13105203flaggier
flaggiest14145513flaggiest
gaggles103512593_gaggles
haggis11209513_haggi_s
haggises1335883_haggises
haggles123312483_haggles
hoagies112811993hoa_gies
jaggier16339183_jaggier
jaggiest17289323_jaggiest
luggies93011213_luggies
magpies12310363_magpies
moggies113111723_moggies
mystagogies1871633mystagogies
naggier9309153_naggier
naggiest102610013_naggiest
otalgias944183otalgias
piggies113813483_piggies
quaggier1933853quaggier
quaggiest2044173quaggiest
raggees93710913_raggees
raggles93813283_raggles
sages65339063s_a_g_es
saggars93610683s_aggars
sagged94120013s_agg_ed
sagger84321073s_agg_er
saggers94017083s_aggers
sagging103116103s_agging
sagier73717163s_a_gier
sagiest82617993s_a_giest
sallies73227813s_allies
salties73725773s_alties
sanies63031953s_a_nies
sarges75128593s_arg_es
sassies74719263s_assies
sauries72821623s_auries
savvies1337603s_avvies
scabies11613333sca_bies
scampies1439333scampies
scanties103215423scanties
scraggier1344133scraggier
scraggiest1444373scraggiest
shagged134210133shagg_ed
shaggily1643773shaggily
shagginess1543933shagginess
shagging14349053shagging
shammies15259693shammies
shandies122714113shandies
shannies113411263shannies
shanties113116593shanties
sharpies13411233sharpies
shavies134213213sha_vies
slagged104312773slagg_ed
slagging113711583slagging
slangier9117933slangier
slangiest10129083slangiest
smarties10312873smarties
smoggier1243973smoggier
smoggiest1334463smoggiest
smuggles12225443smuggles
snagged104010673snagg_ed
snagging11319373snagging
sniggles10307313sniggles
snuggles10306143snuggles
soggier93410883s_oggier
soggiest102711643s_oggiest
spangles1138893spangles
sparges104016343sparg_es
spavies123012953spa_vies
stabiles10311403stabiles
stables93219073sta_bles
stactes91914633sta_ctes
staddles10258693staddles
stades74626243sta__des
stadias8411113sta_dias
stage65330193sta_g_e_
staged84521563sta_g_ed
stager74821343sta_g_er
stagers84116673sta_gers
stagey105915583sta_g_ey
staggard1144513staggard
staggards1244123staggards
staggart1046643staggart
staggarts1143753staggarts
staggered1244473staggered
staggerer1143923staggerer
staggerers1242933staggerers
staggery13346243staggery
staggy115510393stagg__y
stagily1139053sta_gily
staginess1038753staginess
staging93818373sta_ging
stagings10378343stagings
stagnates1046733stagnates
stags66226743sta_g__s
staigs75414813sta__igs
stains64923653sta__ins
stairs65416333sta__irs
staithes1138953staithes
stakes103927293sta__kes
stales65538293sta__les
stalkier1257073stalkier
stalkiest1347913stalkiest
stances93715963sta_nces
stanches132312793stanches
standees93310143standees
stanes64933403sta__nes
stanged94113843stang_ed
stanging104013653stanging
stangs75018163stang__s
stanines85115673stanines
stannites947023stannites
stapedes11197753stapedes
stapes85028733sta__pes
staples93617213sta_ples
starches131912913starches
stares66038753sta__res
stargazes1944083stargazes
starrier8279463starrier
starriest9159773starriest
startles82111963startles
starves104614553sta_rves
stases64225563sta__ses
stashes103916173sta_shes
stasis63116873sta_si_s
states64337083sta__tes
statices102712343statices
statics93314533sta_tics
statins73719773sta_tins
statives112710793statives
statues74614903sta_tues
statures83711113statures
statuses8409543statuses
statutes8368893statutes
staves94525193sta__ves
steadies9311123steadies
steelies8312553steelies
stickies142211973stickies
sties55132983st___ies
stiffies14258383stiffies
stimies9316563st_imies
stingier9279123stingier
stingiest10209773stingiest
stithies1139233stithies
stodges9309083stodg_es
stodgier1034223stodgier
stodgiest1135653stodgiest
stogie7311323st_ogie_
stooges83611483stoog_es
stoolies8311083stoolies
stories7324273st_ories
straggle10359133straggle_
straggled12296853straggled
straggler11377293straggler
stragglers12305253stragglers
stragglier1243503stragglier
straggliest1343613straggliest
stranges94516763strang_es
strangles103011553strangles
strategies1155593strategies
strigils946853strigils
struggles11255283struggles
studdies10207073studdies
studies82413863st_udies
sturdies92110273sturdies
stymies1239213st_ymies
swabbies15115713swabbies
swages104417073swa_g_es
swagged13419153swagg_ed
swagger12389333swagg_er
swaggers13407223swaggers
swagging14328093swagging
swamies123712063swa_mies
syzygies2441343syzygies
tabbies112913503_tabbies
taffies133012693_taffies
tagged93418123_tagg_ed
tagger84017703_tagg_er
taggers93514193_taggers
tagging103014913_tagging
taglines92210833_taglines
talkies113415733_talkies
tallies73624603_tallies
tammies113814683_tammies
tangier83013903_tangier
tangiest92915223_tangiest
tangles83920043_tangles
tansies74521243_tansies
tardies84225863_tardies
targes74524593_targ_es
tarries73324263_tarries
tassies74918933_tassies
tatties74120343_tatties
tawnies102812503_tawnies
tawpies12309873_tawpies
taxies135817333_ta_xies
toggles93710973_toggles
veggies1237553_veggies
waggles123812003_waggles

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622486.48322545.4
3Display Results2482480.0932666.7
 (SQL Overall)1786912486.99925530.9
 
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.