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 “glimmers” 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
glimmers1339615(None) 
glimmer12437711glimmer_
limmers113413081_limmers
slimmers12369631slimmers
aglimmer1342342aglimmer_
brimmers14287072brimmers
clammers143510692clammers
climbers14318412climbers
crimmers14298542crimmers
dimmers123811562_dimmers
gammers123214562g_ammers
gimmes113010902g_imme_s
gleamers11306562gleamers
gliders94811842gli_ders
glimes94717522gli_me_s
glimmered1543102glimmered
glimpsers1442192glimpsers
glisters93912602glisters
glitters93710542glitters
glummer12417982glummer_
grimmer123510092grimmer_
gummers123712202g_ummers
krimmers16315672krimmers
limbers113614742_limbers
limmer104314792_limmer_
limners93311562_limners
limpers113815222_limpers
rimmers113812882_rimmers
shimmers15269412shimmers
simmers113314612_simmers
skimmers16296462skimmers
slammers123511222slammers
slimmer114211342slimmer_
slummers12358932slummers
swimmers15276692swimmers
trimmers12288912trimmers
aimers84621913_ai_mers
alieners889823alieners
aligners9117573aligners
aliners74717723ali_ners
almners9399563al_mners
blamers115314213bl_amers
blinders113911143blinders
blinkers14388503blinkers
blisters104015083blisters
blithers134711233blithers
blitzers19417153blitzers
bloomers12348823bloomers
brimmer13348803brimmer_
bummers133712443_bummers
chimers144515143chi_mers
claimers12298743claimers
clambers144211293clambers
clammer134211793clammer_
clampers143211893clampers
clickers163910203clickers
climber13449133climber_
climes104720003cli_me_s
clingers113810663clingers
clinkers14339833clinkers
clippers14368843clippers
clivers123411753cli_vers
clumbers143910413clumbers
crammers14369353crammers
crimmer133310773crimmer_
crimpers14318933crimpers
cummers133713483_cummers
dammers123214273_dammers
dimers94321093_di_mers
dimmer114112613_dimmer_
drummers13316163drummers
emmers104013223__emmers
epimers11109493epi_mers
filmers124211293_filmers
firmers124711443_firmers
flamers124616363fl_amers
flickers17338883flickers
fliers94417193fli__ers
flinders12439263flinders
flingers123410193flingers
flippers15338003flippers
flirters11337933flirters
flitters114312173flitters
flivvers1733113flivvers
flummery1833053flummery
gainers84214593gai_ners
gaiters83516543gai_ters
gamers94420833g__amers
gammer1112318333g_ammer_
gibbers124710983g_ibbers
gibers95114663g_i_bers
gilders94212463g_ilders
gillers84216903g_illers
gimels938893g_i_mels
gimlets10338433g_imlets
gimmals12225823g_immals
gimme102411343g_imme__
gimmies123010113g_immies
gingers94118643g_ingers
ginners84314223g_inners
gippers123212083g_ippers
girders9379943g_irders
givers104817713g_i_vers
glaciers11277903glaciers
glamors1068123gl_amors
glamours1184743glamours
glancers11408003glancers
glanders103811503glanders
glazers174410043gl_azers
glaziers18406563glaziers
gleamer10328513gleamer_
gleaners9348073gleaners
glibber1235163glibber_
glibness1134133glibness
glider84614263gli_der_
glides84518863gli_de_s
glime85620193gli_me__
glimed105312283gli_me_d
glimmering1643713glimmering
glimmerings1751873glimmerings
glimpser1342663glimpser_
glimpses1343953glimpses
glims87417673gli_m__s
gliomas1035333gliom_as
glistens9366593glistens
glister84013343glister_
glitter84211803glitter_
glittery12375613glittery
glitzes17367563glitze_s
gloaters9288863gloaters
glomera1035943gl_omera
glommed13265443glomme_d
glossers9319053glossers
glovers114310883gl_overs
glowers113412093gl_owers
gluers75011153gl__uers
glumes94516813gl_ume_s
glummest13235563glummest
glumness1135203glumness
goiters84014443goi_ters
gomers94116883g__omers
grammars13345943grammars
grammes123611323gramme_s
gridders11286293gridders
grievers1255473grievers
grifters12389233grifters
grillers93810813grillers
grimacers1463553grimacers
grimes94619033gri_me_s
grimier103210433grimier_
grimmest13286293grimmest
grimness1175993grimness
grinders103410423grinders
grinners9288043grinners
gripers104011463gri_pers
grippers13358133grippers
gristers94013403gristers
gritters94210633gritters
grommets13234663grommets
groomers11388483groomers
grummer12338783grummer_
grummets13275033grummets
guiders94111113gui_ders
guilders1035513guilders
guimpes1245073guimpe_s
gummer114615453g_ummer_
hammers144216063_hammers
hemmers143310843_hemmers
hummers143813063_hummers
immerse1145793__immerse
jammers183710703_jammers
klezmers2341583klezmers
klisters123910483klisters
krimmer15376873krimmer_
lambers113817113_lambers
lampers113817333_lampers
libbers113812833_libbers
libers84721443_li_bers
lickers134118253_lickers
liers55130403_li__ers
lifers95617843_li_fers
lifters104313783_lifters
ligers75022043_li_gers
likers104620913_li_kers
limber104316793_limber_
limens84618033_li_mens
limes75636503_li_me_s
limeys11429273_li_meys
limier83518723_limier_
limiters10249333_limiters
limner84112873_limner_
limper104117853_limper_
limpets11329783_limpets
liners65428853_li_ners
lingers84223303_lingers
linkers114317713_linkers
linters73822633_linters
lippers113416443_lippers
lispers94514323_lispers
listers74026533_listers
liters65429883_li_ters
litters73422573_litters
livers94927823_li_vers
liviers104211073_liviers
livyers13365903_livyers
lumbers113815913_lumbers
lumpers113514483_lumpers
maimers113813043mai_mers
mammers104615693_mammers
mimers105520183_mi_mers
mummers103712843_mummers
oligomers1243533oligomers
pliers84715153pli__ers
plinkers14309393plinkers
plumbers14418513plumbers
plummer13298523plummer_
plummets14304773plummets
plumpers14357293plumpers
primers114215673pri_mers
primmer134310163primmer_
rammers113715043_rammers
reimmerse1343013reimmerse
rimers84522553_ri_mers
rimmer103516033_rimmer_
rummers113513653_rummers
scammers14339773scammers
scummers14277783scummers
shammers153710843shammers
shimmer143310873shimmer_
shimmery18265253shimmery
simmer104115353_simmer_
simpers113014123_simpers
skimmer15327533skimmer_
slammer113913033slammer_
slicers94114923sli_cers
slickers143112553slickers
sliders83515223sli_ders
slimes84722043sli_me_s
slimier93212013slimier_
slimmed12368473slimme_d
slimmest1235903slimmest
slimness1036523slimness
slingers93712683slingers
slippers123711233slippers
slithers114212953slithers
slitters84014133slitters
slivers104115253sli_vers
slumbers123110273slumbers
slummer113711203slummer_
spammers14378693spammers
stammers123611523stammers
stemmers12378443stemmers
summers113616503_summers
swimmer14297653swimmer_
timbers113111853_timbers
timers84420993_ti_mers
trimers94615143tri_mers
trimmer113610833trimmer_
tsimmes1133673tsimme_s
tzimmes2033063tzimme_s
uglifiers1343093uglifiers
unlimbers1342583unlimbers
whimpers18276613whimpers
yammers143410323_yammers

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 Limit1461622647.12620511.1
3Display Results2642640.1102400.0
 (SQL Overall)1786912647.65923330.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.