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

142 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
glittered1119541(None) 
flittered13196251flittered
glistered11176301glistered
littered92511381_littered
bittered112711832_bittered
blattered12198572blattered
blistered12167682blistered
blithered15156122blithered
chittered15166412chittered
clattered12178412clattered
cluttered12185942cluttered
flattered13188632flattered
fluttered13185942fluttered
frittered13205162frittered
gettered10258612g_ettered
glimmered1543102glimmered
glistened11174282glistened
glitter84211802glitter__
glitters93710542glitter_s
glittery12375612glitter_y
guttered10259162g_uttered
jittered16267222_jittered
lettered92910782_lettered
litterer82810172_litterer
skittered1434632skittered
slithered13136622slithered
tittered9239492_tittered
twittered1333812twittered
aglitter935093aglitter__
altered83215743al__tered
battered113315053_battered
bettered113011843_bettered
bistered112913333_bistered
bitterer10309773_bitterer
blathered15168363blathered
blethered15165433blethered
blinkered1644413blinkered
blustered12157263blustered
buttered112712623_buttered
chattered15197993chattered
clatterer11186993clatterer
clinkered1634773clinkered
cloistered1344513cloistered
clustered12186613clustered
cottered112511733_cottered
dithered13189293_dithered
embittered1542543embittered
fettered12259493_fettered
filtered12259043_filtered
flattened13185303flattened
flatterer12187683flatterer
flichtered1942133flichtered
flickered1943753flickered
flitted114011643flitt__ed
flitter103413903flitter__
flitters114312173flitter_s
flustered13185883flustered
flutterer12185263flutterer
fritterer12234403fritterer
gartered10319593g_artered
gathered13149383g_athered
gibbered1444303g_ibbered
gingered11127743g_ingered
gitted84015053g_itt__ed
gittern8337503g_itter_n
gitterns9326573g_itterns
glaciered1343883glaciered
glandered1236343glandered
glinted9399373glint__ed
glister84013343glister__
glisters93912603glister_s
glitterati1162253glitterati
glittering1296003glittering
glitzed18375493gli_t_zed
glowered1345753gl_owered
glutted937243glutt__ed
gritted94110903gritt__ed
gritter83913353gritter__
gritters94210633gritter_s
imbittered1542083imbittered
kittened1334523_kittened
lathered121512333_lathered
leistered1037043leistered
letterer8259223_letterer
lightered1446283_lightered
limbered13158123_limbered
lingered10129643_lingered
lippered13287953_lippered
listened9168813_listened
litter64324853_litter__
litterers9228193_litterers
litters73422573_litter_s
littery103710493_litter_y
livered113111633_li_vered
loitered938183_loitered
lustered92510603_lustered
mattered112412903_mattered
mitered103213233_mi_tered
mittened1136363_mittened
muttered112610793_muttered
nattered92011623_nattered
outglittered145763outglittered
pattered112714203_pattered
philtered1545493philtered
plaistered1344133plaistered
plastered1288903plastered
pottered112311663_pottered
puttered112611143_puttered
relettered1144333relettered
reuttered1036073reuttered
roistered1037643roistered
scattered12197353scattered
scuttered12166423scuttered
shattered13178203shattered
shuttered13156333shuttered
sintered92213903_sintered
sistered92612803_sistered
slathered13148553slathered
slippered1434823slippered
slitted83513313slitt__ed
slitter73615873slitter__
slitters84014133slitter_s
slivered12218103sli_vered
smattered12186783smattered
spattered12187643spattered
splattered13163943splattered
splintered1383923splintered
spluttered13153173spluttered
sputtered12166323sputtered
stuttered10145763stuttered
swithered16135463swithered
tattered92011443_tattered
titterer8268523_titterer
tottered9208703_tottered
twitterer1243303twitterer
unlettered1143953unlettered
unuttered1065733unuttered
uttered82712433__uttered
waitered1238753wai_tered
wintered122111573_wintered
withered15169433_withered
yattered12239533_yattered

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 Limit1486411427.07621006.4
3Display Results1421420.0632254.0
 (SQL Overall)1786911427.56223630.1
 
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.