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

113 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
glistered1117630(None) 
blistered12167681blistered
glistened11174281glistened
glittered11195411glittered
bistered112913332_bistered
blustered12157262blustered
cloistered1344522cloistered
clustered12186612clustered
flittered13196252flittered
flustered13185882flustered
glimmered1543102glimmered
glister84013342glister__
glisters93912602glister_s
leistered1037042leistered
listened9168812_listened
littered92511382_littered
lustered92510612_lustered
plaistered1344132plaistered
plastered1288912plastered
roistered1037652roistered
sistered92612802_sistered
altered83215753al__tered
banistered1394623banistered
bistred103311853_bist_red
bittered112711833_bittered
blattered12198583blattered
blinkered1644413blinkered
blister94415313blister__
blisters104015083blister_s
blistery13418713blister_y
blithered15156123blithered
blusterer11176293blusterer
bolstered1246093bolstered
chittered15166413chittered
clattered12178423clattered
clinkered1634773clinkered
cluttered12185943cluttered
delustered1243293delustered
festered122512113_festered
filtered12259043_filtered
flattered13188643flattered
flichtered1942133flichtered
flickered1943753flickered
fluttered13185943fluttered
fostered122210453_fostered
frittered13205163frittered
gartered10319603g_artered
gestured1036993g_estured
gettered10258613g_ettered
gibbered1444303g_ibbered
gingered11127743g_ingered
glaciered1343883glaciered
glandered1236343glandered
glinted9399373glint__ed
glissaded1242293glissaded
glisten8418083glist__en
glistens9366593gliste_ns
glistering12106423glistering
glitter84211803glitter__
glitters93710543glitter_s
glittery12375613glitter_y
glitzed18375493gli_t_zed
glowered1345753gl_owered
grister83915413grister__
gristers94013413grister_s
guttered10259173g_uttered
holstered1345883holstered
jittered16267223_jittered
klister113410643klister__
klisters123910483klister_s
lettered92910783_lettered
lightered1446283_lightered
limbered13158123_limbered
lingered10129643_lingered
lippered13287953_lippered
listed74322833_list__ed
listee64223063_liste_e_
listees73416673_liste_es
listener8158313_listener
lister64527253_lister__
listeria839453_listeria
listers74026533_lister_s
litterer82810173_litterer
livered113111633_li_vered
lobstered1244643lobstered
loitered938183_loitered
lustred8359053_lust_red
mastered112614013_mastered
ministered1344963ministered
mistermed1438363_mistermed
mitered103213233_mi_tered
moistened1246003moistened
mustered112511513_mustered
oystered1236923_oystered
pestered112814973_pestered
philtered1545493philtered
plasterer1178113plasterer
registered1245293registered
roisterer946433roisterer
roystered1344873roystered
sintered92213903_sintered
skittered1434633skittered
slippered1434823slippered
slithered13136623slithered
slivered12218103sli_vered
splintered1383923splintered
tittered9239493_tittered
twittered1333813twittered
waitered1238763wai_tered
westered122511873_westered
whiskered20123393whiskered
whispered18144373whispered
wintered122111573_wintered

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411137.08020994.5
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.54923670.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.