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

161 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
eaten5532305(None) 
beaten84617061beaten
eater54639841eater
laten54328341laten
neaten64214541neaten
oaten55222401oaten
paten74827341paten
amen66733152_amen
ate37059242_ate_
ates45047922_ates
bate66552422bate_
bated85935532bated
bates75846342bates
batmen104414302batmen
baton75822422baton
batten85217122batten
beater84729392beater
cate66254602cate_
catena8312482catena
cater74840722cater
cates75951892cates
date56443322date_
dated75530992dated
dater65332312dater
dates65639152dates
daven94916472daven
dawen95413722dawen
deaden83714322deaden
deafen10389672deafen
eager65526972eager
eared65139502eared
earn46737552ea_rn
earthen1039252earthen
ease45042332ease_
eased65430402eased
easel54521112easel
eases56041612eases
easter65027982easter
eastern74412532eastern
eat36989052eat__
eaters65535952eaters
eatery95316352eatery
eath75735662eat_h
eating75134402eating
eats47054872eat_s
eave75733582eave_
eaved95924502eaved
eaves85231992eaves
elate55335882elate_
elated74725822elated
elater64724202elater
elates65032362elates
enate54428152enate_
enates64026432enates
enter54726382enter
ester54727712ester
even75222272e_ven
examen1538282examen
extend14267522extend
extent132714912extent
extern1348472extern
eyen76223662e_yen
fasten95114892fasten
fate75444282fate_
fated95632132fated
fates85139232fates
fatten94314902fatten
feater95224052feater
gaen57329602ga_en
gate55746572gate_
gated75329772gated
gater64533652gater
gates65939512gates
greaten83610642greaten
haen76229452ha_en
hapten115312982hapten
hasten95718562hasten
hate78450172hate_
hated95734022hated
hater85034752hater
hates86742572hates
haven114718532haven
hearten102411752hearten
heated104525592heated
heater94828302heater
heathen133410892heathen
heaven123912602heaven
laden65022192laden
late47560482late_
lated65240672lated
lateen64014862lateen
latens64620212latens
latent64124302latent
later54843922later
latex124717112latex
latten65018202latten
leaden74515222leaden
leaven95013072leaven
lenten6312882lenten
marten84518262marten
mate65154222mate_
mated85537782mated
mater74438862mater
mates75251362mates
matey107022662matey
matin75132852matin
maven104816892maven
meated94222402meated
meatmen1138242meatmen
nates55238332nates
neatens73310402neatens
neater64424312neater
oaken95814382oaken
oater55433732oater
often84611412often
pate65350462pate_
pated85237842pated
patens84820862patens
patent84524922patent
pater74740722pater
pates76047892pates
patin76832852patin
patten84418192patten
peahen113410132peahen
peasen84815962peasen
pecten102711102pecten
platen84518202platen
ramen75625192ramen
ratan53722662ratan
rate45458762rate_
rated65441382rated
ratel54224882ratel
rater54943282rater
rates55352012rates
ratten64217382ratten
raven84723442raven
sate45556102sate_
sated66238532sated
sateen63815012sateen
satem76021462satem
sates54949322sates
satin55935222satin
seamen84518562seamen
seated75131062seated
seater64534162seater
taken94819142taken
tate44748602tate_
tater54138612tater
tates55444982tates
tauten64311892tauten
teated74924022teated
ten35856112__ten
uneaten7412542uneaten
waken124818472waken
water84733312water
waxen154911812waxen
weaken13349602weaken
wheaten1336402wheaten
yamen104115182yamen
zazen1337282zazen
zeatin15412822zeatin

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 Filter178691538000.313570897.8
2DLD Change Limit538001611.78030224.7
3Display Results1611610.0463500.0
 (SQL Overall)1786911612.13983539.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.