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 “legatees” 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
legatees925843(None) 
legatee82814631legatee_
legates82917681legat_es
delegatees1244272delegatees
legacies1139042legacies
legalese954752legalese
legaleses1044392legaleses
legate72917452legat_e_
legated92513982legat_ed
legators92811032legators
legatos82711182legat_os
ligates82318382ligat_es
negaters9349782negaters
negates83215842negat_es
ablegates1246793ablegat_es
aerates74627493aerat_es
agates76121343_agat_es
beaters94925043be_aters
begazes1937963bega_zes
berates94126873berat_es
bleaters103412323ble_aters
cerates95428253cerat_es
coatees93816553_coatees
debaters113511923debaters
debates103718533debat_es
degames113312623dega_mes
degases93413103dega_ses
degasses10278363degasses
degrees92810723deg_rees
delates83526283delat_es
delegatee1148803delegatee_
delegates1139843delegat_es
departees1265723departees
derates84028893derat_es
devotees12286283devotees
dewaters122910723dewaters
eaters65535953_e_aters
eglateres1044453_eglateres
elaters74420193_elaters
elates65032363_elat_es
electees10238723electees
elegances1246183elegances
elevateds13122883elevateds
elevates111110423elevat_es
eluates72014683eluat_es
enates64026433_enat_es
ergates8314493ergat_es
gaters74728643__gaters
gates65939513__gat_es
gelates83219593gelat_es
goatees82710443_goatees
heaters104225223he_aters
ingates82716913ingat_es
larees65323113l__arees
lateen64014863l__ateen
lateens74210553l__ateens
latens64620213l__atens
latexes1438313l__atexes
lathes95127503l__athes
latkes104715873l__atkes
lattes65324203l__attes
leaches123319343le_aches
leadens83610983le_adens
leaders83819603le_aders
leaguers935063leaguers
leagues837943le_agues
leakers113415423le_akers
lealties8310793lealties
leaners73718173le_aners
leapers93716663le_apers
leasers74717843le_asers
leases65428113le_a_ses
leashes103514403le_ashes
leather103815783le_ather
leathers114215083le_athers
leavens10409303le_avens
leavers103717783le_avers
leaves94222383le_a_ves
lefties10312073le_fties
legalise949493legalise
legalises1038563legalises
legalities1148913legalities
legalizes1938673legalizes
legals73412733lega__ls
legatine91311403legatine
legating102313113legating
legation92412933legation
legations102711923legations
legato72810953legat__o
legator83011133legat_or
legers74518313leg__ers
leges64427293leg___es
legits71313003legit__s
legless838013leg_less
legumes1036633leg_umes
leisters83312823leisters
lenites7818443lenit_es
lenities8315943lenities
lessees73510243le_ssees
lethes94818083le__thes
letters73819853le_tters
levanters1254993levanters
levatores12225743levatores
levators11249283levators
levees93714523le__vees
levigates1346493levigat_es
levities11310713levities
ligases82310713liga_ses
ligate72519253ligat_e_
ligated92414143ligat_ed
ligatures1044933ligatures
lightens122510003lightens
lighters123111393lighters
listees73416673l_istees
loathes103513243l_oathes
locaters102710073locaters
locates93218813locat_es
luxates1436973luxat_es
lysates10317473lysat_es
manatees10310423manatees
megasses11307743megasses
megatheres1644853megatheres
megatons11279703megatons
mentees93214503me_ntees
mestees94617753me_stees
metates92720013metat_es
neatens73310403ne_atens
negate72915573negat_e_
negated93413233negat_ed
negater83711963negat_er
negatives1346583negatives
negatons9299273negatons
negators92411173negators
oleates7417833ole_at_es
penates93321603penat_es
pleaters103613793ple_aters
pugarees11195493pugarees
rebaters103413943rebaters
rebates95123183rebat_es
redates83423873redat_es
regalers94311133regalers
regales83520793rega_les
regather1236733regather
regathers1336353regathers
regattas944473regattas
regauges1046093regauges
regrates92618403regrat_es
relaters83218153relaters
relates73731433relat_es
relegates10310943relegat_es
remates93827113remat_es
repartees1147253repartees
seaters74028943se_aters
sedates83418043sedat_es
senates73322613senat_es
settees73513633se_ttees
testees74215913te_stees
vestees103513173ve_stees

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621587.44019645.4
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.92322553.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.