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

158 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
legacies113904(None) 
delegacies1444032delegacies
elegancies1345012elegancies
leaches123319342le_aches
legalise949492legalise
legalises1038562legalises
legalizes1938672legalizes
legatees9258432legatees
legates82917682lega_tes
lunacies1038012lunacies
abbacies1445483abbacies
agencies1138743agencies
angaries9314393angaries
beaches144120653be_aches
beanies93821093be_anies
begazes1937963bega_zes
beggaries1356233beggaries
beladies11310423beladies
bigamies1337373bigamies
bleaches153410673ble_aches
cenacles1238023cenacles
curacies12311763curacies
dearies83526273de_aries
debacles1335723debacles
defaces133213403defac_es
degames113312623dega_mes
degamis11268443degami_s
degases93413103dega_ses
degasses10278363degasses
detaches1439653detaches
digamies1238643digamies
easies64126633_e_asies
egalites9310503_egalites
elegances1246183elegances
elegies81312903eleg__ies
facies113921593__facies
gabies93820733__gabies
heavies132713873he_avies
hegaris11310433hegari_s
laces76141763l__ac_es
laches116528343l__aches
lacier84020093l__acier
laciest93819033l__aciest
ladies75124883l__adies
lazies154418783l__azies
leached133715043le_ached
leacher124014843le_acher
leachers133712813le_achers
leachier1337253le_achier
leachiest1437243le_achiest
leadier83212723le_adier
leadiest93314983le_adiest
leafier10329833le_afier
leafiest113410883le_afiest
leagues837943le_agues
leakier114010993le_akier
leakiest123212793le_akiest
lealties8310793lealties
learier73415663le_arier
leariest83117843le_ariest
leases65428113le_a_ses
leashes103514403le_ashes
leaves94222383le_a_ves
leavier10319993le_avier
leaviest112910813le_aviest
leches115421313le__ches
leeches123911933le_eches
lefties10312073le_fties
legacy1256653legac__y
legalese954753lega_lese
legaleses1044393legaleses
legalised1145843legalised
legalism1148583legalism
legalisms1247163legalisms
legalist9512393legalist
legalists1047943legalists
legalities1148913legalities
legality1237623legality
legalize1839103legalize
legalized2047523legalized
legalizer1946323legalizer
legalizers2044103legalizers
legals73412733lega__ls
legate72917453lega_te_
legated92513983lega_ted
legatee82814633lega_tee
legatine91311403legatine
legating102313113legating
legation92412933legation
legations102711923legations
legators92811033legators
legatos82711183lega_tos
leges64427293leg___es
leggier9368233leg_gier
leggiest10308233leg_giest
leggins9259473leg_gins
legits71313003leg__its
legumes1036633leg_umes
legumins1144993legumins
lehayims1641743lehayims
lenities8315943lenities
letches124015483le_tches
leucines1037273le_ucines
leucins938103le_ucins
leucites1037333le_ucites
levies93919863le__vies
levities11310713levities
lezzies1536203le_zzies
ligases82310713liga_ses
ligates82318383liga_tes
litanies8310993litanies
literacies1248803literacies
loaches123613983l_oaches
logicise1146113logicise
logicises1256203logicises
logicizes2145933logicizes
luggies93011213lug_gies
mealies92821933me_alies
meanies93620743me_anies
mediacies1447183mediacies
megabits1355793megabits
megacities1546673megacities
megacity1645713megacity
megahits1445683megahits
megasses11307743megasses
menaces112715523menac_es
mercies113817563me_rcies
negates83215843nega_tes
negatives1346583negatives
oogamies1147413oogamies
papacies1439473papacies
peaces106324083pe_ac_es
peaches144120053pe_aches
peavies122213403pe_avies
peracids13310073peracids
piracies12312643piracies
pleaches153210433ple_aches
plenaries11410383plenaries
prelacies13310053prelacies
reaches123423203re_aches
readies83324713re_adies
refaces123216743refac_es
regains84316583rega_ins
regales83520793rega_les
regauges1046093regauges
regencies1249283regencies
regicides1345813regicides
regnancies1345413regnancies
relaces93420883relac_es
teaches122718353te_aches
tenaces92814513tenac_es
tenancies1149173tenancies
testacies1148373testacies
tetanies8513553tetanies
vagaries12310293vagaries
veggies1237553veg_gies
vegies104314273veg__ies
wearies103020223we_aries

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.436409841.7
2DLD Change Limit1461621586.40622816.4
3Display Results1581580.0632507.9
 (SQL Overall)1786911586.90525878.5
 
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.