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

114 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
leistered103704(None) 
bistered112913322_bistered
blistered12167682blistered
cloistered1344512cloistered
festered122512102fe_stered
glistered11176292glistered
leister73212752leister__
leisters83312822leister_s
leisured934762leis_ured
lettered92910782le_ttered
listened9168812l_istened
littered92511382l_ittered
lobstered1244642lobstered
loitered938182loi_tered
lustered92510602l_ustered
pestered112814962pe_stered
plaistered1344132plaistered
registered1245292registered
roistered1037642roistered
sistered92612802_sistered
westered122511862we_stered
banistered1394623banistered
bettered113011833be_ttered
bistred103311853_bist_red
bittered112711833_bittered
blustered12157263blustered
bolstered1246093bolstered
centered112513523ce_ntered
chittered15166413chittered
clustered12186613clustered
delustered1243293delustered
dewatered1444743dewatered
entered82718883_e_ntered
fettered12259493fe_ttered
filtered12259043_filtered
flittered13196253flittered
flustered13185883flustered
fostered122210453_fostered
frittered13205163frittered
gestured1036993ge_stured
gettered10258613ge_ttered
glistened11174283glistened
glittered11195403glittered
heisted113210653heist__ed
heister103613623heister__
heisters113413133heister_s
holstered1345883holstered
jittered16267223_jittered
keister113011573keister__
keisters123212043keister_s
leaguered1143223leaguered
leathered13148713leathered
lechered1437523le_chered
lectured11127223le_ctured
leered73816223le___ered
leistering1147983leistering
leisure736693leis_ure_
leisures836683leis_ures
lessened935093le_ssened
letterer8259223le_tterer
levered114212303le__vered
lightered1446283lightered
limbered13158123l_imbered
lingered10129643l_ingered
lippered13287953l_ippered
listed74322833l_ist__ed
listee64223063l_iste_e_
listees73416673l_iste_es
listener8158313l_istener
lister64527253l_ister__
listeria839433l_isteria
listers74026533l_ister_s
litterer82810173l_itterer
livered113111633l_i_vered
lobsterer1144033lobsterer
loiterer837083loi_terer
lustred8359053l_ust_red
mastered112614003_mastered
meister93114163meister__
meisters103313843meister_s
metered103514013me__tered
ministered1344963ministered
mistermed1438363_mistermed
mitered103213233_mi_tered
moistened1246003moistened
mustered112511503_mustered
neutered937423ne_utered
oystered1236923_oystered
peltered112510453pe_ltered
pesterer102412703pe_sterer
petered103314973pe__tered
philtered1545493philtered
plastered1288893plastered
realtered1037893realtered
reentered1038573reentered
refiltered1443773refiltered
reinterred1145153reinterred
remastered1345643remastered
restored96417193re_stored
reuttered1036073reuttered
roisterer946433roisterer
roystered1344873roystered
sintered92213903_sintered
skittered1434633skittered
teetered9258303te_etered
tentered96412103te_ntered
tittered9239493_tittered
twittered1333813twittered
vestured1237463ve_stured
waitered1238753wai_tered
weltered12238433we_ltered
whiskered20123393whiskered
whispered18144373whispered
wintered122111573_wintered

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411148.23618047.7
3Display Results1141140.0462478.3
 (SQL Overall)1786911148.71820496.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.