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

188 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
lechered143752(None) 
blethered15165432blethered
lackered15108672lackered
lathered121512322lathered
leathered13148712leathered
leched123716002lech__ed
lecher113415852lecher__
lecheries1449072lecheries
lechers123313962lecher_s
lechery15257642lecher_y
lectured11127222lectured
leered73816222le__ered
lettered92910782lettered
levered114212302le_vered
lichened1435752lichened
ochered132610282_ochered
rechewed1735632rechewed
tethered1238492tethered
tochered1437912tochered
adhered1239233_adhered
anchored1438593anchored
beavered1437503beavered
becharmed1944663becharmed
bettered113011833bettered
bickered17108003bickered
blathered15168353blathered
blithered15156123blithered
bothered142110393bothered
butchered1744583butchered
cacheted16148233cacheted
centered112513523centered
cered85227443__c_ered
chared125423693__chared
checkered2144683checkered
cheered133713293__cheered
chefed155010563__chefed
chewed154415013__chewed
chored125321883__chored
ciphered1637053ciphered
cockered17710213cockered
cohered133514693_cohered
coshered14610293coshered
cyphered1934653cyphered
dackered16116893dackered
decerned1237263dec_erned
deciphered1943003deciphered
declared1248743declared
decreed112710253decre_ed
dickered16117533dickered
dithered13189293dithered
echard1249223_echar_d
eched116919223_ech__ed
echoed125211153_ech_oed
entered82718883_entered
eschewed1743443eschewed
euchred13106163euch_red
fathered151510433fathered
feathered16188893feathered
fendered13258673fendered
festered122512103festered
fettered12259493fettered
fevered14339723fe_vered
fleered11309503fle__ered
flichtered1942133flichtered
flickered1943753flickered
gathered13149373gathered
gendered11258873gendered
gettered10258613gettered
glaciered1343863glaciered
hachured1744393hachured
heathered16149463heathered
hectored1436873hectored
inhered11313163_inhered
jeered143912793je__ered
kashered1636403kashered
koshered1636063koshered
laagered1055853laagered
lackeyed18104513lackeyed
lacquered2143363lacquered
laddered1136743laddered
lagered92311153l_agered
lappered13288213lappered
latherer111310443latherer
laveered1235253laveered
lawyered1534033lawyered
layered11259413l_ayered
leached133715043leach__ed
leacher124014843leacher__
leachers133712813leacher_s
leadened1036153leadened
leaguered1143223leaguered
leavened1235553leavened
lechering1538443lechering
lecherous1445033lecherous
leches115421313lech__es
lechwe1435113lech_we_
lechwes1535063lech_wes
lectern937033lecter_n
lecterns1035943lecterns
lecture9149513lecture_
lecturer10136023lecturer
lectures101310153lectures
leeched13369503leech__ed
leistered1037043leistered
leisured934763leisured
lessened935093lessened
letched133912053letch__ed
letterer8259223letterer
leveed104111373le_ve_ed
leveled114010383le_veled
leveret103014003le_veret
lichee114017973liche_e_
lichees123512783liche_es
lichted13268803lich_ted
lightered1446283lightered
limbered13158123limbered
lingered10129643lingered
lippered13287953lippered
littered92511383littered
livered113111633l_ivered
loitered938183loitered
loppered13326753loppered
louvered1244993louvered
lowered112711913l_owered
lumbered13188233lumbered
lustered92510603lustered
lychee143710893lyche_e_
lychees15516783lyche_es
membered1535903membered
metered103514013me_tered
mothered142310103mothered
neutered937423neutered
nickered15117023nickered
ochred12328003_och_red
peched144915343pech__ed
peered93819483pe__ered
peltered112510443peltered
peppered1236123peppered
pestered112814953pestered
petered103314963pe_tered
pothered142311043pothered
puckered1736103puckered
racheted14149503racheted
receded112713043rec_eded
recharged1656333recharged
recharted1557563recharted
rechecked2143973rechecked
recovered15166733recovered
recurred1137093recurred
rehired115013153re_hired
rendered102512263rendered
revered112819333re_vered
richened1435953richened
sacheted14127833sacheted
schemed1577753_schemed
seceded11319203sec_eded
secerned1136103sec_erned
secreted1138633secreted
sectored1138063sectored
secured1059723sec_ured
severed113513863se_vered
sewered112911243se_wered
slathered13148543slathered
slithered13136623slithered
sphered133512313_sphered
suckered1537833suckered
syphered1755013syphered
teched124014433tech__ed
teddered11255183teddered
teetered9258303teetered
telfered1234883telfered
telphered1544213telphered
tempered13248213tempered
tendered102510603tendered
tentered96412103tentered
tuckered1535963tuckered
ulcered1037973ulc_ered
unchewed1735803unchewed
ushered1139153_ushered
vectored1435623vectored
veered103612743ve__ered
veneered1235983veneered
vouchered1843853vouchered
weathered16168513weathered
weltered12238433weltered
westered122511863westered
withered15169433withered
wuthered15157433wuthered

Search took 7 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.1561145455.1
2DLD Change Limit1461621886.45322650.2
3Display Results1881880.0802350.0
 (SQL Overall)1786911886.68926714.2
 
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.