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

265 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
legatee8281463(None) 
legate72917451legat_e
legated92513981legated
legatees9258431legatees
legates82917681legates
delegatee1148802delegatee
legalese954752legalese
legatine91311402legatine
legato72810952legat_o
legator83011132legator
legatos82711182legatos
ligate72519252ligat_e
ligated92414142ligated
ligates82318382ligates
negate72915572negat_e
negated93413232negated
negater83711962negater
negates83215842negates
ablegate1147253ablegat_e
ablegates1246793ablegates
aerate64830553aerat_e
aerated85322373aerated
aerates74627493aerates
agate66525153_agat_e
agates76121343_agates
beaten84617063be_aten
beater84729393be_ater
begat86629723begat__
begaze1838333bega_ze
begazed2036203begazed
begazes1937963begazes
belated103520013belated
berate84729023berat_e
berated104422133berated
berates94126873berates
bleated104015973ble_ated
bleater94515303ble_ater
cerate84829463cerat_e
cerated103922473cerated
cerates95428253cerates
cleated103417843cle_ated
coatee84327223_coatee
debate94419193debat_e
debated113916083debated
debater104114693debater
debates103718533debates
degage92711383dega_ge
degame102713183dega_me
degames113312623degames
degases93413103degases
degree82814853deg_ree
delate73827753delat_e
delated93722873delated
delates83526283delates
delegate10410463delegat_e
delegated1238373delegated
delegatees1244273delegatees
delegates1139843delegates
departee1139723departee
derate74531233derat_e
derated93623503derated
derates84028893derates
devotee113811823devotee
dewater112912423dewater
eaten55323053_e_aten
eater54639843_e_ater
eglatere945153_eglatere
elate55335883_elat_e
elated74725823_elated
elater64724203_elater
elates65032363_elates
electee92513243electee
elegance1146373elegance
elevate101110373elevat_e
elevated12118293elevated
elevates111110423elevates
eluate62315433eluat_e
eluates72014683eluates
enate54428153_enat_e
enates64026433_enates
ergate7315143ergat_e
ergates8314493ergates
feater95224053fe_ater
fedayee1445513fedayee
gate55746573__gat_e
gated75329773__gated
gater64533653__gater
gates65939513__gates
gelate73421253gelat_e
gelated93615633gelated
gelates83219583gelates
goatee73219533_goatee
heated104525593he_ated
heater94828303he_ater
ingate73018243ingat_e
ingates82716913ingates
jugate14379463jugat_e
lanate6421263lanat_e
lanated8313203lanated
laree56036293l__aree
late47560483l__at_e
lated65240673l__ated
lateen64014863l__ateen
laten54328343l__aten
later54843923l__ater
latex124717113l__atex
lathe85626713l__athe
latke94817093l__atke
latte55426303l__atte
leaded84221543le_aded
leaden74515223le_aden
leader74824653le_ader
leafed105713873le_afed
league758743le_ague
leagued935463leagued
leaguer835793leaguer
leagues837943leagues
leaked114217703le_aked
leaker104620073le_aker
leaned73422543le_aned
leaner64022193le_aner
leaped94317773le_aped
leaper88118943le_aper
lease55230263le_a_se
leased74722883le_ased
leaser65322673le_aser
leases65428113le_ases
leather103815783le_ather
leave84723723le_a_ve
leaved105719023le_aved
leaven95013073le_aven
leaver94321513le_aver
leaves94222383le_aves
lefter93613433le_fter
legacies1139043legacies
legacy1256653lega_cy
legal65715943lega__l
legaleses1044393legaleses
legalise949493legalise
legalize1839103legalize
legally1138133legally
legals73412733lega_ls
legating102313113legating
legation92412933legation
legators92811033legators
leger65721513leg__er
leges64427293leg__es
legged95713093leg_ged
leggier9368233leggier
legible1035833legible
legit61323503legit__
legits71313003legit_s
leglike12136843leglike
legmen939343leg_men
legume936913leg_ume
legumes1036633legumes
leister73212753leister
lenite6719983lenit_e
lenited8812433lenited
lenites7818443lenites
lenten6312883le_nten
lessee64116363le_ssee
lethe85717303le__the
letted74118543le_tted
letter63722583le_tter
levanted1245323levanted
levanter1145303levanter
levator10298963levator
levee84023813le__vee
levigate1246623levigat_e
levigated1445643levigated
levigates1346493levigates
ligase7259913liga_se
ligases82310713ligases
ligative1258803ligative
ligature945133ligature
lighted122913503lighted
lighten112811523lighten
lighter113113443lighter
listee64223063l_istee
loathe94211383l_oathe
lobate82915243lobat_e
lobated102610943lobated
locate83919843locat_e
located103114183located
locater93113603locater
locates93218813locates
lunate6316043lunat_e
lunated8310823lunated
luxate1338083luxat_e
luxated1535713luxated
luxates1436973luxates
lyrate94112103lyrat_e
lyrated11388473lyrated
lysate9388103lysat_e
lysates10317473lysates
manatee9317663manatee
meated94222403me_ated
megasse10266243megasse
megathere1544733megathere
megaton10269853megaton
mentee84121293me_ntee
mestee84523883me_stee
metate82720533metat_e
metates92720013metates
neaten64214543ne_aten
neater64424313ne_ater
negaters9349783negaters
negative1239083negative
negaton8299143negaton
negator83010673negator
oleate6318883ole_at_e
oleates7417833ole_ates
pedate93117763pedat_e
penates93321603penates
pleated103816633ple_ated
pleater93916333ple_ater
pugaree10208033pugaree
rebate84424113rebat_e
rebated103619703rebated
rebater93517913rebater
rebates95123183rebates
redate74124683redat_e
redated93120923redated
redates83423873redates
regale74821453rega_le
regaled93615963regaled
regaler83814623regaler
regales83520793regales
regather1236733regather
regatta835963regatta
regauge945813regauge
regave104713383rega_ve
regrate82618663regrat_e
regrated102816333regrated
regrates92618403regrates
relate64033633relat_e
related83327573related
relater73723143relater
relates73731433relates
relegate9311243relegat_e
relegated1139763relegated
relegates10310943relegates
remate84428683remat_e
remated103522473remated
remates93827113remates
repartee10312753repartee
rugate75813813rugat_e
seated75131063se_ated
seater64534163se_ater
sedate73019813sedat_e
sedated93714353sedated
sedater83713633sedater
sedates83418043sedates
senate63725173senat_e
senates73322613senates
settee63721023se_ttee
teated74924023te_ated
testee64323303te_stee
togate74515683togat_e
togated94410663togated
ungated92717213ungated
vegete1039483veget_e
velate93720143velat_e
vestee94319153ve_stee

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272656.72019944.5
3Display Results2652650.0932849.5
 (SQL Overall)1786912657.21924752.9
 
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.