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

296 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
lettered9291078(None) 
bettered113011831bettered
fettered12259491fettered
gettered10258611gettered
letterer8259221letterer
littered92511381littered
battered113315052battered
bittered112711832bittered
blattered12198562blattered
blethered15165432blethered
buttered112712622buttered
centered112513522centered
clattered12178402clattered
cluttered12185942cluttered
cottered112511732cottered
entered82718882_entered
festered122512102festered
fetterer11207812fetterer
flattered13188622flattered
flittered13196252flittered
fluttered13185942fluttered
glittered11195402glittered
guttered10259162guttered
jittered16267222jittered
lathered121512322lathered
leathered13148712leathered
lechered1437522lechered
lectured11127222lectured
leered73816222le__ered
leistered1037042leistered
letted74118542lett__ed
letter63722582letter__
letterers9228112letterers
letterhead1442352letterhead
lettermen1164282lettermen
letters73819852letter_s
levered114212302le_vered
litterer82810172litterer
loitered938182loitered
lustered92510602lustered
mattered112412902mattered
metered103514012me_tered
muttered112610792muttered
nattered92011622nattered
neutered937422neutered
pattered112714202pattered
peltered112510442peltered
pestered112814952pestered
petered103314962pe_tered
pottered112311662pottered
puttered112611142puttered
relettered1144332relettered
reuttered1036072reuttered
tattered92011442tattered
teetered9258302teetered
tentered96412102tentered
tethered1238492tethered
tittered9239492tittered
tottered9208702tottered
unlettered1143952unlettered
uttered82712432_uttered
weltered12238432weltered
westered122511862westered
yattered12239532yattered
altered83215733_altered
antlered938253antlered
attired8238913_attired
bantered113313633bantered
bartered113113013bartered
battened11259573battened
batterer102713213batterer
beavered1437503beavered
betattered1343143betattered
betted94721163bett__ed
better84723703better__
betters94422093better_s
bistered112913323bistered
bitterer10309773bitterer
blathered15168353blathered
blistered12167683blistered
blithered15156123blithered
blustered12157263blustered
bothered142110393bothered
cantered113415983cantered
catered103117773_catered
centred103411683cent_red
chattered15197993chattered
chittered15166413chittered
clatterer11186983clatterer
clustered12186613clustered
cratered1149683cratered
deterged11127923de_terged
deterred10137803deterred
detoured1036513detoured
dewatered1444743dewatered
dithered13189293dithered
dotterel945063dotterel
elaterid948613elaterid
enfettered1442483enfettered
enterer72015633_enterer
faltered122810983faltered
fathered151510433fathered
fattened12268283fattened
feathered16188893feathered
featured1237683featured
fendered13258673fendered
fetted104817893fett__ed
fetter94120383fetter__
fetterers12267043fetterers
fetters103517903fetter_s
fettled11378933fett_led
fevered14339723fe_vered
filtered12259043filtered
flattened13185303flattened
flatterer12187673flatterer
fleered11309503fle__ered
flustered13185883flustered
flutterer12185263flutterer
fostered122210443fostered
frittered13205163frittered
gartered10319583gartered
gathered13149373gathered
gendered11258873gendered
gestured1036993gestured
getter74117613getter__
getters84216103getter_s
glistered11176293glistered
haltered123112553haltered
heathered16149463heathered
hectored1436873hectored
jeered143912793je__ered
jetted143915083jett__ed
jettied15366973jett_ied
kittened1334523kittened
laagered1055853laagered
lackered15108673lackered
laddered1136743laddered
lagered92311153l_agered
lappered13288213lappered
latened8711923l_atened
laterad8310843l_aterad
latherer111310443latherer
latter65027893latter__
latterly1136063latterly
latticed1134793latticed
laveered1235253laveered
lawyered1534033lawyered
layered11259413l_ayered
leadened1036153leadened
leaguered1143223leaguered
leavened1235553leavened
lectern937033lecter_n
lecterns1035943lecterns
lecture9149513lecture_
lecturer10136023lecturer
lectures101310153lectures
lefter93613433lefter__
leisured934763leisured
leotard846193leotar_d
leotarded1142783leotarded
lessened935093lessened
letched133912053le_tched
letterbox1852143letterbox
letterboxed2151463letterboxed
letterheads1552153letterheads
lettering102112073lettering
letterman1164243letterman
lettuce943323lettuce_
lettuces1043503lettuces
leveed104111373le_ve_ed
leveled114010383le_veled
leveret103014003le_veret
lightered1446283lightered
limbered13158123limbered
lingered10129643lingered
lippered13287953lippered
listened9168813listened
litter64324853litter__
litterers9228193litterers
litters73422573litter_s
littery103710493litter_y
livered113111633l_ivered
lobstered1244633lobstered
loiterer837083loiterer
loppered13326753loppered
lotted74222403lott__ed
lotter64025603lotter__
lotteries9311073lotteries
lotters73921063lotter_s
lottery10389833lotter_y
louvered1244993louvered
lowered112711913l_owered
lumbered13188233lumbered
lustred8359053lust_red
mastered112614003mastered
membered1535903membered
mentored1138003mentored
metred95315143me_t_red
mettled103510543mett_led
mitered103213233_mitered
mittened1136363mittened
mothered142310103mothered
mustered112511503mustered
mutterer10218913mutterer
neatened937043neatened
netted74118713nett__ed
netter63722023netter__
netters73618583netter_s
nettled8339943nett_led
oystered1236913oystered
paltered113012483paltered
pattened11299393pattened
patterer103112173patterer
patterned1265743patterned
peered93819483pe__ered
peppered1236123peppered
pesterer102412703pesterer
petted94121523pett__ed
petter83924773petter__
petters93722363petter_s
pettled103611503pett_led
pewterer13256313pewterer
plastered1288893plastered
portered112311533portered
pothered142311043pothered
potterer102310263potterer
putterer10209913putterer
raftered1237663raftered
rattened9218623rattened
realtered1037893realtered
reentered1038573reentered
rendered102512263rendered
restored96417193restored
retired84620143re_tired
retted74826313rett__ed
revered112819333re_vered
scattered12197353scattered
sceptered1444723sceptered
scuttered12166423scuttered
sectored1138063sectored
settee63721023sette_e_
settees73513633sette_es
setter64023723setter__
setters73822063setter_s
settled83210873sett_led
severed113513863se_vered
sewered112911243se_wered
shattered13178203shattered
sheltered1335573sheltered
shuttered13156333shuttered
sintered92213903sintered
sistered92612803sistered
skeltered1443873skeltered
skittered1434633skittered
slathered13148543slathered
slithered13136623slithered
smattered12186783smattered
spattered12187643spattered
splattered13163933splattered
spluttered13153173spluttered
sputtered12166323sputtered
steered83615253_steered
stuttered10145763stuttered
sweltered1344453sweltered
teddered11255183teddered
telfered1234883telfered
tempered13248213tempered
tendered102510603tendered
tetter64322453tetter__
tetters74320473tetter_s
textured1695483textured
tiered73613973__tiered
titterer8268523titterer
totterer8217793totterer
twittered1333813twittered
unentered1037573unentered
unfettered1443653unfettered
unuttered1065733unuttered
utterer71910463_utterer
vectored1435623vectored
veered103612743ve__ered
veneered1235983veneered
ventured1238273ventured
vestured1237463vestured
vetted104316323vett__ed
vetter93417643vetter__
vetters104016323vetter_s
waitered1238753waitered
watered113014953_watered
weathered16168513weathered
wetted103717023wett__ed
wetter93919443wetter__
wetters103817753wetter_s
wintered122111573wintered
withered15169433withered
wuthered15157433wuthered

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622968.00018270.3
3Display Results2962960.1861591.4
 (SQL Overall)1786912968.35921377.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.