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 “enates” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
enates6402643(None) 
elates65032361elates
enate54428151enate_
nates55238331_nates
penates93321601penates
senates73322611senates
abates85825032abates
aerates74627492aerates
agates76121342agates
agnates82813192agnates
alates64833962alates
annates72415422annates
antes56334322an_tes
ates45047922__ates
bates75846342_bates
benames112814602benames
berates94126872berates
cates75951892_cates
cenotes92814542cenotes
cerates95428252cerates
crates85736062crates
dates65639152_dates
debates103718532debates
delates83526282delates
denotes83817002denotes
derates84028892derates
donates83217222donates
eases56041612e_ases
eaten55323052e_aten
eater54639842e_ater
eaters65535952e_aters
eats47054872e_at_s
eaves85231992e_aves
ecartes94212562ecartes
elate55335882elate_
elated74725822elated
elater64724202elater
elaters74420192elaters
elites66027122elites
eluates72014682eluates
elutes64020312elutes
emanates10311332emanates
emotes84620282emotes
enables92813122enables
enacted10310642enacted
enacts84012972enacts
enamel81210112enamel
enamels9128162enamels
enatic8317562enatic
encages103313782encages
encases93116052encases
endites83717062endites
endues73813902endues
enfaces122110912enfaces
engages92912492engages
enlaces92313392enlaces
enrages83114852enrages
ensues63313812ensues
entases72816272entases
enter54726382en_ter
enters64425642en_ters
enures63919712enures
envies9314052envies
equates162012322equates
erases64425402erases
ergates8314492ergates
estates74520182estates
etapes85415292etapes
evades1039022evades
evites94916472evites
eyases94513682eyases
fates85139232_fates
gates65939512_gates
gelates83219582gelates
gentes75324162gen_tes
gnats65217712gnat_s
grates75429892grates
hates86742572_hates
inanes62519802inanes
ingates82716912ingates
inmates92715782inmates
kentes105118652ken_tes
knaves13439522knaves
knawes13328392knawes
legates82917682legates
lenites7818442lenites
mantes84430782mantes
mates75251362_mates
menaces112715522menaces
menages103615392menages
metates92720012metates
nabes75427092_nabes
names74833362_names
napes74828462_napes
nares55544152_nares
naves87030382_naves
neaten64214542neaten
neatens73310402neatens
neater64424312neater
neatest72516002neatest
neats55931902neat_s
negates83215842negates
neonates8310062neonates
nites55736342_nites
notes55034582_notes
orates64328612orates
pates76047892_pates
phenates13611572phenates
plates85432242plates
prates84633162prates
rates55352012_rates
rebates95123182rebates
redates83423872redates
relates73731432relates
remates93827112remates
renames92418052renames
rentes65431192ren_tes
sates54949322_sates
sedates83418042sedates
senate63725172senate_
sensates8511142sensates
skates104219402skates
slates64934062slates
snakes103919602snakes
snares65329032snares
snathes104816492snathes
snaths95112912snaths
spates85028172spates
states64337082states
tates55444982_tates
tenaces92814512tenaces
unites65024852unites
urates65027762urates
yentes95517602yen_tes

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511342.50033020.4
3Display Results1341340.0462913.0
 (SQL Overall)1786911342.88961852.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.