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

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

51 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
glimmering164371(None) 
glimmerings1751871glimmerings
glistering12106422glistering
glittering1296002glittering
limbering1488792_limbering
shimmering1884622shimmering
simmering1467822_simmering
blinkering1744323blinkering
blistering13107063blistering
blithering16116123blithering
clambering1776163clambering
clinkering1745233clinkering
flickering2044093flickering
flittering1486503flittering
gibbering1534713g_ibbering
gimleting1343863g_imleting
gingering1238873g_ingering
glamouring14113853glamouring
gliming113310133gli_m__ing
glimmer12437713glimmer___
glimmered1543103glimmer_ed
glimmers13396153glimmer__s
glimpsing1542593gli_mpsing
glistening1294283glistening
glomming14275923glomm__ing
glowering1435653gl_owering
grommeting1642913grommeting
grummeting1642453grummeting
hammering1737633_hammering
immerging1544103__immerging
immersing1445123__immersing
immuring1335533__immuring
lingering11310513_lingering
lippering14217883_lippering
littering102411983_littering
livering122012383_li_vering
lumbering14117933_lumbering
mammering1337333_mammering
plummeting1742103plummeting
reimmersing1642823reimmersing
simpering1449293_simpering
slimming13288093slimm__ing
slithering1496893slithering
slivering1338083sli_vering
slumbering15105323slumbering
stammering1544523stammering
summering1458753_summering
timbering14117723_timbering
unlimbering1652483unlimbering
whimpering2143853whimpering
yammering1735193_yammering

Search took 6 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 Filter1786911406030.423422437.4
2DLD Change Limit140603515.43625865.2
3Display Results51510.0163187.5
 (SQL Overall)178691515.87530415.5
 
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.