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 “glimmerings” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
glimmerings175187(None) 
glimmering1643711glimmering_
glimmers13396153glimmer___s
glistering12106423glistering_
glittering1296003glittering_
limbering1488793_limbering_
lumberings15103783_lumberings
shimmering1884623shimmering_
simmering1467823_simmering_
timberings15124093_timberings
blinkering1744324blinkering_
blistering13107064blistering_
blithering16116124blithering_
clambering1776164clambering_
clinkering1745234clinkering_
filmmakings2351294filmmakings
fingerings1545074_fingerings
flickering2044094flickering_
flittering1486504flittering_
flummeries1743764flummeri_es
gatherings15105294g_atherings
gibbering1534714g_ibbering_
gimleting1343864g_imleting_
gingering1238874g_ingering_
glamouring14113864glamouring_
gleyings13283654gl___eyings
gliming113310134gli_m__ing_
glimmer12437714glimmer____
glimmered1543104glimmer__ed
glimpsing1542594gli_mpsing_
glistening1294284glistening_
glitteringly1751864glitteringly
gloamings13254094gloam__ings
glomming14275924glomm__ing_
gloomings13283974gloom__ings
glowering1435654gl_owering_
glycerines1644464gl_ycerines
glycerins1544554gl_ycerin_s
gofferings1842224g_offerings
grommeting1642914grommeting_
grummeting1642454grummeting_
gutterings12224914g_utterings
hammering1737634_hammering_
immerging1544104__immerging_
immersing1445124__immersing_
immuring1335534__immuring_
lawyerings1752584_lawyerings
layerings13235684_l_ayerings
lemmings13254734_lemm__ings
letterings11226004_letterings
limericks1744404_li_mericks
limmers113413084_limmer___s
lingering11310514_lingering_
lippering14217884_lippering_
littering102411984_littering_
livering122012384_li_vering_
lumbering14117934_lumbering_
mammering1337334_mammering_
nidderings1362734_nidderings
niderings1175404_ni_derings
plasterings1444744plasterings
plummeting1742104plummeting_
reimmersing1642824reimmersing_
silverings1443844_silverings
simpering1449294_simpering_
skimmings18243264skimm__ings
slammings14234124slamm__ings
slimmers12369634slimmer___s
slimming13288094slimm__ing_
slithering1496894slithering_
slivering1338084sli_vering_
slumbering15105324slumbering_
stammering1544524stammering_
summering1458754_summering_
swimmings17263154swimm__ings
timbering14117724_timbering_
trimmings14254454trimm__ings
unlimbering1652484unlimbering_
whimpering2143854whimpering_
whisperings2042214whisperings
yammering1735194_yammering_

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 Filter1786911488190.423422437.4
2DLD Change Limit148819817.61019555.7
3Display Results81810.0461760.9
 (SQL Overall)178691818.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.