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

123 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
blistered1216768(None) 
bistered112913321b_istered
blustered12157261blustered
glistered11176291glistered
banistered1394622banistered
bistred103311852b_ist_red
bittered112711832b_ittered
blattered12198562blattered
blinkered1644412blinkered
blister94415312blister__
blisters104015082blister_s
blistery13418712blister_y
blithered15156122blithered
blusterer11176292blusterer
bolstered1246092bolstered
cloistered1344512cloistered
clustered12186612clustered
flittered13196252flittered
flustered13185882flustered
glistened11174282glistened
glittered11195402glittered
leistered1037042leistered
listened9168812_listened
littered92511382_littered
lustered92510602_lustered
plaistered1344132plaistered
plastered1288892plastered
roistered1037642roistered
sistered92612802_sistered
altered83215733al__tered
bantered113313633b_antered
bartered113113013b_artered
battered113315053b_attered
bettered113011833b_ettered
bickered17108003b_ickered
bilsted1038033bilst__ed
bister84922763b_ister__
bisters93922613b_ister_s
bistre83815023b_ist_re_
bistres94017213b_ist_res
bitterer10309773b_itterer
blabbered13184593blabbered
blasted104213473blast__ed
blaster94017303blaster__
blasters104116143blaster_s
blathered15168353blathered
blazered2035063bl_azered
blethered15165433blethered
blissed10388373blis__sed
blistering13107063blistering
blitzed19336533bli_t_zed
blubbered13164113blubbered
blundered1335193blundered
bluster94215313bluster__
blusterers12174993blusterers
blusters104413893bluster_s
blustery13368003bluster_y
bolsterer1145483bolsterer
bristled11187343brist_led
buttered112712623b_uttered
chittered15166413chittered
clattered12178403clattered
clinkered1634773clinkered
cluttered12185943cluttered
delustered1243293delustered
festered122512103_festered
filtered12259043_filtered
flattered13188623flattered
flichtered1942133flichtered
flickered1943753flickered
fluttered13185943fluttered
fostered122210453_fostered
frittered13205163frittered
glimmered1543103glimmered
glister84013343glister__
glisters93912603glister_s
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__
listeria839433_listeria
listers74026533_lister_s
litterer82810173_litterer
livered113111633_li_vered
lobstered1244643lobstered
loitered938183_loitered
lustred8359053_lust_red
mastered112614003_mastered
ministered1344963ministered
mistermed1438363_mistermed
mitered103213233_mi_tered
moistened1246003moistened
mustered112511503_mustered
oystered1236923_oystered
pestered112814963_pestered
philtered1545493philtered
plasterer1178103plasterer
registered1245293registered
roisterer946433roisterer
roystered1344873roystered
sintered92213903_sintered
skittered1434633skittered
slippered1434823slippered
slithered13136623slithered
slivered12218103sli_vered
splintered1383923splintered
tittered9239493_tittered
twittered1333813twittered
waitered1238753wai_tered
westered122511863_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.436409841.7
2DLD Change Limit1486411237.00021234.4
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.48223882.8
 
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.