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

457 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
glitters9371054(None) 
flitters114312171flitters
glisters93912601glisters
glitter84211801glitter_
glittery12375611glittery
gritters94210631gritters
litters73422571_litters
slitters84014131slitters
aglitter935092aglitter_
bitters94920362_bitters
blatters104414092blatters
blisters104015082blisters
blithers134711232blithers
blitzers19417152blitzers
blotters104110982blotters
chitters133711172chitters
clatters103313912clatters
clutters103210352clutters
critters103511332critters
emitters10349642emitters
fitters104517752_fitters
flatters113814202flatters
flirters11337932flirters
flitter103413902flitter_
flutters114010822flutters
fritters113810782fritters
gaiters83516542gai_ters
getters84216102g_etters
gittern8337502g_ittern
gitterns9326572g_itterns
gliders94811842gli_ders
glimmers13396152glimmers
glistens9366592glistens
glister84013342glister_
glittered11195412glittered
glitzes17367562glitze_s
gloaters9288862gloaters
goiters84014442goi_ters
grifters12389232grifters
gristers94013412gristers
gritter83913352gritter_
gutters83715512g_utters
hitters104717592_hitters
jitters144314472_jitters
klisters123910482klisters
knitters12336622knitters
letters73819852_letters
lifters104313782_lifters
linters73822632_linters
listers74026532_listers
liters65429882_li_ters
litter64324852_litter_
littery103710492_littery
lotters73921062_lotters
omitters10277652omitters
platters103415282platters
plotters104011552plotters
quitters17238522quitters
ritters74020622_ritters
sitters74221552_sitters
skitters12349552skitters
slithers114212952slithers
slitter73615872slitter_
slotters84012402slotters
spitters104113382spitters
splitters11307322splitters
titters74219622_titters
twitters11296772twitters
whitters14359402whitters
abetters1057173abetters
abutters1056993abutters
admitters1244553admitters
alieners889823alieners
aligners9117573aligners
aliners74717723ali_ners
allotters965563allotters
alters64924223al__ters
baiters94619313bai_ters
batters94626023_batters
belittlers1242023belittlers
betters94422093_betters
bisters93922613_bisters
biters83925243_bi_ters
bitter84622673_bitter_
bittern94810683_bittern
bitterns10428953_bitterns
blasters104116143blasters
blathers134713793blathers
blatter94415653blatter_
bleaters103412323bleaters
blethers13429613blethers
blighters1555743blighters
blinders113911143blinders
blinkers14388503blinkers
blister94415313blister_
blistery13418713blistery
blites84721213bli_te_s
blither124812173blither_
blitzer18447663blitzer_
blitzes18408703blitze_s
bloaters103311023bloaters
blotter94612853blotter_
blurters10348373blurters
blusters104413893blusters
butters94521723_butters
chatters134213953chatters
chitter124112963chitter_
citers85022983_ci_ters
cithers124315773_cithers
cittern9339143_cittern
citterns10318123_citterns
clatter94014973clatter_
clattery13378193clattery
clickers163910203clickers
climbers14318413climbers
clingers113810663clingers
clinkers14339833clinkers
clippers14368843clippers
clivers123411753cli_vers
cloisters1137443cloisters
clouters10399803clouters
clusters102912403clusters
clutter94211663clutter_
cluttery13346323cluttery
clysters13227843clysters
cointers103616423cointers
cotters94323453_cotters
critter94113033critter_
critturs10374593critturs
cutters94218963_cutters
dieters83216433_dieters
dilaters92513063dilaters
diluters9288113diluters
dithers114016153_dithers
dotters83715973_dotters
drifters12417913drifters
elaters74420193el_aters
elites66027123eli_te_s
embitters13334723embitters
emitter93211083emitter_
enlisters937113enlisters
fainters11349693fainters
fetters103517903_fetters
filisters1237003filisters
filters103816553_filters
fitter94120033_fitter_
flattens11357483flattens
flatter103815963flatter_
flattery14338293flattery
flichters1774173flichters
flickers17338883flickers
fliers94417193fli__ers
flinders12439263flinders
flingers123410193flingers
flippers15338003flippers
flirter10318673flirter_
flites95122443fli_te_s
flitted114011643flitte_d
flittered13196253flittered
flivvers1733113flivvers
floaters112711513floaters
flouters11419273flouters
flusters113811503flusters
fluters103713683fl_uters
flutter104012093flutter_
fluttery14376143fluttery
flytiers14254483flytiers
fretters113410303fretters
fritter103912773fritter_
gagsters10317083gagsters
gainers84214593gai_ners
gaiter73819503gai_ter_
galettes93111163galette_s
ganisters10248313ganisters
garotters1055033garotters
garters84218233g_arters
gasters85624293g_asters
gaters74728643g__aters
gathers114315073g_athers
getter74117613g_etter_
gibbers124710983g_ibbers
gibers95114663g_i_bers
giftees11306513g_iftees
gilders94212463g_ilders
gillers84216903g_illers
gingers94118643g_ingers
ginners84314223g_inners
gippers123212083g_ippers
girders9379943g_irders
gites65630183g_i_te_s
gitted84015053g_itte_d
givers104817713g_i_vers
glaciers11277903glaciers
glancers11408003glancers
glanders103811503glanders
glazers174410043gl_azers
glaziers18406563glaziers
gleamers11306563gleamers
gleaners9348073gleaners
glibber1235163glibber_
glibness1134143glibness
glider84614263gli_der_
glides84518863gli_de_s
glimes94717523gli_me_s
glimmer12437713glimmer_
glimpsers1442193glimpsers
glinted9399373glinte_d
glintier945703glintier_
glints75714213glint__s
glisten8418083gliste_n
glistered11176303glistered
glitches14296663glitches
glitterati1162253glitterati
glittering1296003glittering
glitzed18375493glitze_d
glitzier1833593glitzier_
gloater83711013gloater_
glossers9319053glossers
glottis837173glott_is
glovers114310883gl_overs
glowers113412093gl_owers
gluers75011153gl__uers
glutens8437593gl_utens
glutes74517673gl_ute_s
gluteus8386253gl_uteus
glutted937243glutte_d
gluttons944273gluttons
goiter74116203goi_ter_
goitres8389563goitre_s
grafters12409193grafters
granters93614143granters
graters85419743g_raters
greeters92610113greeters
gridders11286293gridders
grievers1255473grievers
grifter113810493grifter_
grillers93810813grillers
grinders103410423grinders
grinners9288043grinners
gripers104011463gri_pers
grippers13358133grippers
grister83915413grister_
gritted94110903gritte_d
grittier9316263grittier_
grouters95910083grouters
grunters9359033grunters
guiders94111113gui_ders
guilders1035513guilders
guitars8116863gui_tars
gutter73817713g_utter_
guttery11427763g_uttery
guttlers9306933guttlers
gypsters1434023gypsters
hatters104221523_hatters
heisters113413133heisters
hinters103719583_hinters
hitter94419863_hitter_
hoisters113513493hoisters
igniters9126233igni_ters
imbitters13274503imbitters
inters64328053__inters
jilters144211963_jilters
jitter133314993_jitter_
jittery17346443_jittery
jointers15289323jointers
jotters143413803_jotters
keisters123212043keisters
kilters113813603_kilters
kiters105218593_ki_ters
kittens11347583_kittens
klister113410643klister_
knitter11348133knitter_
knotters12276153knotters
lasters75627693_lasters
lathers104321883_lathers
lattens75014673_lattens
latter65027893_latter_
lattes65324203_latte_s
leisters83312823leisters
letter63722583_letter_
libbers113812833_libbers
libers84721443_li_bers
lickers134118253_lickers
lictors93212603_lictors
liers55130403_li__ers
lifers95617843_li_fers
lifter93814813_lifter_
ligers75022043_li_gers
lighters123111393_lighters
likers104620913_li_kers
limbers113614743_limbers
limiters10249333_limiters
limmers113413083_limmers
limners93311563_limners
limpers113815223_limpers
liners65428853_li_ners
lingers84223303_lingers
linkers114317713_linkers
lintels73311163_lintels
linter64625343_linter_
lippers113416443_lippers
lispers94514323_lispers
listees73416673_listees
listels74212433_listels
listens74014133_listens
lister64527253_lister_
liter54736343_li_ter_
lither94520953_lither_
litotes7311183_litote_s
litres65220393_litre_s
litten64014873_litte_n
littered92511383_littered
litterer82810173_litterer
litterers9228193_litterers
littler7348553_littler_
littles73212783_littles
livers94927823_li_vers
liviers104211073_liviers
livyers13365903_livyers
lofters103912903_lofters
loiters74116613_loiters
looters74419163_looters
lotter64025603_lotter_
lottery10389833_lottery
lottes65322753_lotte_s
lusters73921443_lusters
matters94421753_matters
meisters103313843meisters
milters93619093_milters
minters93822473_minters
misters93927513_misters
miters84328783_mi_ters
mithers123516733_mithers
mittens9349883_mittens
mutters94117143_mutters
natters73718063_natters
netters73618583_netters
niters64624213_ni_ters
nutters74215433_nutters
oldsters996733oldsters
omitter9298503omitter_
otters64021513__otters
outglitters1271393outglitters
painters103013023painters
patters94825193_patters
petters93722363_petters
philters1398173philters
pitiers93812653_pitiers
plaisters1137813plaisters
plaiters103512633plaiters
planters102915323planters
plasters103518133plasters
platers93924093pl_aters
platter93917413platter_
pleaters103613793pleaters
pliers84715153pli__ers
plighters1545533plighters
plinkers14309393plinkers
plotter94113663plotter_
pointers103013723pointers
potters94024343_potters
printers103214903printers
putters94219193_putters
quieters17248733quieters
quilters17228433quilters
quitter162910753quitter_
quittors17155413quittors
ratters74422473_ratters
reinters82614773reinters
reletters9138783reletters
remitters11328403remitters
reutters8138573reutters
rioters73615523_rioters
ritter63822423_ritter_
roisters83615563roisters
rotters74421393_rotters
scatters103612753scatters
scutters103311023scutters
setters73822063_setters
shatters113313913shatters
shifters14319863shifters
shutters113611353shutters
sifters103714793_sifters
sinters74024083_sinters
sisters73721593_sisters
sitter63323383_sitter_
skirters12337243skirters
skitter113810403skitter_
skittery15315103skittery
slaters73123733sl_aters
slathers113914783slathers
slattern837093slattern
slatterns935363slatterns
slicers94114923sli_cers
slickers143112553slickers
sliders83515223sli_ders
slighters1346713slighters
slimmers12369633slimmers
slingers93712683slingers
slippers123711233slippers
slither104112983slither_
slithery14356703slithery
slitless8268143slitless
slitted83513313slitte_d
slittier837003slittier_
slivers104115253sli_vers
slotter73314453slotter_
smatters104011713smatters
smiters93414363smi_ters
smithers13369793smithers
snifters11318613snifters
spatters103914703spatters
spitter94015183spitter_
splatters11327543splatters
splinters11277923splinters
splitter10348443splitter_
splutters11286273splutters
spotters104313383spotters
sputters104012873sputters
stinters83312753stinters
stutters83210473stutters
suiters73618883sui_ters
swatters113911793swatters
swifters14277483swifters
swithers144310533swithers
swotters11448483swotters
tatters74520483_tatters
tetters74320473_tetters
tilters73315953_tilters
tinters74221113_tinters
titers64526413_ti_ters
titfers10318933_titfers
tithers104216733_tithers
titter63421163_titter_
totters74618733_totters
trotters83310243trotters
twisters11268173twisters
twitter10278093twitter_
twittery14303893twittery
uglifiers1343093uglifiers
ulsters72711983ul_sters
uniters73814173uni_ters
uplifters1463283uplifters
utters63817123__utters
vetters104016323_vetters
waisters113811523waisters
waiters104218623wai_ters
wetters103817753_wetters
whetters14246653whetters
whitter139110893whitter_
whittlers1594333whittlers
winters103720483_winters
withers134417753_withers
writers105513493wri_ters
writhers14398983writhers
yatters103914623_yatters
zithers193911973_zithers

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.420425454.8
2DLD Change Limit1461624577.22020244.0
3Display Results4574570.1862457.0
 (SQL Overall)1786914577.82622833.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.