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

357 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
enations8331690(None) 
elations83719121elations
enation73419231enation_
nations74720561_nations
venations12311721venations
adnations1039752adnations
aerations9317902aerations
agnations10310032agnations
alations82518892alations
cations94524142_cations
conations111318902conations
crenations12511692crenations
delations102616592delations
dentations11413632dentations
donations101112352donations
editions9310402editions
elation73620452elation_
elutions82513052elutions
emanations1289592emanations
emotions10610282emotions
equations1839492equations
erasions8310982erasions
evasions1136542evasions
exactions1838922exactions
fetations12511382fetations
gelations102513092gelations
gnathions1343302gnathions
inactions1139322inactions
kations114013662_kations
legations102711922legations
lenitions939472lenitions
lunations9310722lunations
mentations12312582mentations
mentions10312892men_tions
nasions73112382_nasions
nation64322802_nation_
natrons73215662_natrons
negations102811962negations
notions74014482_notions
orations81515802orations
ovations11149262ovations
rations74123432_rations
relations92418332relations
sedations10311252sedations
sensations1059852sensations
stations82415222stations
unctions1039732unctions
venation11513502venation_
vernations13310332vernations
vexations1937752vexations
zonations18139312zonations
ablations11311513ablations
actions94218513_actions
adaptions1245223adaptions
adnation9310783adnation_
aeration8319933aeration_
agnation9311723agnation_
alation72920553alation_
alienations1147883alienations
amotions1069843amotions
anattos7138453anatto_s
animations12312193animations
anions64123033__anions
antlions839193antlions
auctions104012143auctions
aviations12311553aviations
avions94114393__avions
axions134713483__axions
basions94213953_basions
bastions10411693bastions
batons85519423_bat_ons
benthons1337973ben_thons
betatrons1145083betatrons
bevatrons1443713bevatrons
camions113916133_camions
cantons95221203cant_ons
captions123813223captions
carnations12311353carnations
catenations1348363catenations
cation83925503_cation_
cautions103313183cautions
ceratins102818733cerati_ns
cessations1256473cessations
chelations1539073chelations
citations11312503citations
clarions10310493clarions
coactions1349743coactions
cognations1339593cognations
coitions10312853coitions
conation101420883conation_
connations12312943connations
cratons94316033crat_ons
creations112614543creations
cremations14410713cremations
crenation11412923crenation_
damnations1337083damnations
darnations1138413darnations
dealations11311373dealations
deflations1439713deflations
delation92318083delation_
deletions102610933deletions
demotions1258443demotions
denegations1348543denegations
denotations1239853denotations
dentation10315243dentation_
dentins83419223den_ti_ns
dentitions1148853dentitions
denudations1346343denudations
detonations1239373detonations
deviations14311163deviations
devotions1356593devotions
diatrons939613diatrons
dictions111812673dictions
dilations102614453dilations
donation91513783donation_
dotations101411633dotations
durations10311463durations
dynatrons1343393dynatrons
eating75134403e_ati_ng
eatings84616443e_atings
edacious1146023edacious
edition8310853edition_
educations1339233educations
eductions1268773eductions
egestions1046703egestions
ejections18249963ejections
elains64919853ela_i_ns
elastins82111743elasti_ns
elating83423083elati_ng
elatives1139783elatives
elections112414973elections
elevations1338633elevations
elisions82210423elisions
elongations1244663elongations
elusions82610083elusions
elution72913823elution_
emanation11910783emanation_
emendations1446053emendations
emetins9812653emeti_ns
emoticons1353783emoticons
emotion9711303emotion_
emptins1179403empti_ns
emulations12310943emulations
enacting11311363enacti_ng
enactors1038453enactors
enamine91214313enami_ne
enamines101112133enamines
enamors939123ena_mors
enates64026433enat__es
enatic8317563enati__c
endrins8312163endri_ns
enervations1478573enervations
enjoins1457333enjoi_ns
ensigns836353en_signs
entails7912823entai_ls
enterons8314153enterons
entices91616333en_tices
entires71517783en_tires
entoils7810733en_toils
envious1037223en_vious
environs1144673environs
envisions1245613envisions
epilations12311713epilations
equation17310483equation_
erasion7311963erasion_
erections112515213erections
erosions8310343erosions
eruptions1146763eruptions
etalons739073eta_lons
etamins91511833etami_ns
etatisms1038293etatisms
ethions1038483e_thions
evasion1036753evasion_
evections142510693evections
evictions14228623evictions
evocations15259873evocations
exaction1738953exaction_
excitons1746043excitons
exertions1639763exertions
expiations1959663expiations
exudations18107073exudations
factions133013063factions
fanions103713073_fanions
fellations1338063fellations
fenthions1544233fenthions
fetation11613143fetation_
fictions132410743fictions
fixations1936353fixations
flatirons1244483flatirons
fractions1449103fractions
functions1437743functions
gabions102410053_gabions
gelatins93414093gelati_ns
gelation93014433gelation_
geminations14139263geminations
gemmations1545003gemmations
generations12311423generations
gentians937563gen_tians
gestations1139773gestations
gnathion1243443gnathion_
gratins84119183grati_ns
gyrations1336923gyrations
halations12312393halations
hematins131714683hemati_ns
herniations1447403herniations
himations1438803himations
ideations1039903ideations
ignitions1045803ignitions
illations9311393illations
inaction1039623inaction_
inanitions1046383inanitions
incautions1245973incautions
inflations13310323inflations
inions64417003in__ions
introns73515023in_trons
invasions12115413invasions
iodations1039113iodations
isatins7310773isati_ns
iterations10413823iterations
junctions1835943junctions
kation104315683_kation_
kenotrons1344523kenotrons
keratins122313483kerati_ns
latinos73613803_latinos
lavations1238973lavations
laxations1637623laxations
lections102413843lections
legation92412933legation_
lenition8310083lenition_
libations112510443libations
ligations102111993ligations
lineations1039543lineations
lobations11219613lobations
locations112512743locations
lotions74614763_lotions
lunation8311923lunation_
luxations1637273luxations
mansions1069793mansions
matins84527783_mati_ns
matrons93517633_matrons
mediations13310983mediations
megatons11279703megat_ons
menadione1243783menadione
menadiones1343783menadiones
menazons1945733mena_zons
mentation11313983mentation_
mention9314373men_tion_
monitions11310883monitions
motions94215003_motions
munitions1138173munitions
mutations111211453mutations
nasion63914083_nasion_
natations91412493natations
national8311533_national
nationals948863_nationals
natives10310823_natives
natron64116023_natron_
neatens73310403neat_ens
negation92913023negation_
negatons9299273negat_ons
negatrons10275843negatrons
nektons1136393nekt_ons
nervations1359483nervations
neutrons838293neutrons
newtons1036813newt_ons
nidations1039213nidations
nitons64614903_nit_ons
nonactions1248373nonactions
notations91512973notations
notion64516583_notion_
novations12139003novations
nunnations1095903nunnations
nutations91411763nutations
oblations1139373oblations
onions64016433on__ions
operations12312953operations
options93810603_options
oration71617713oration_
ovation101510023ovation_
ozonations1945143ozonations
pactions122613503pactions
patins87528783_pati_ns
patios85221783_patio_s
patrons93818103_patrons
peltations12311553peltations
pensions10311693pen_sions
pentagons1246153pentagons
petitions11511083petitions
phonations1538313phonations
pinnations1236883pinnations
planations1238723planations
platoons1038683platoons
portions10514413portions
potations111615073potations
potions93417423_potions
predations13812153predations
prenotions1248293prenotions
pronations12314033pronations
punitions1137923punitions
pupations1338123pupations
ration64226013_ration_
ratios64922673_ratio_s
ratoons73815473_ratoons
rattons73815323_rattons
reactions11711713reactions
recautions1247813recautions
redactions1359133redactions
reflations13311233reflations
relation82619773relation_
remotions1149703remotions
renditions1149183renditions
renovations1448423renovations
restations10315843restations
rogations101510823rogations
rotations91613843rotations
ructions102811683ructions
ruinations1039603ruinations
sanctions1138873sanctions
satins64930483_sati_ns
sections102714703sections
sedation9312453sedation_
seditions1039013seditions
senators8312953senat_ors
sensation9510583sensation_
seriations10316683seriations
serrations10313093serrations
sinuations1039413sinuations
solations9814623solations
statins73719773stati_ns
station72717243station_
suasions838783suasions
suctions103012903suctions
sudations1039903sudations
tactions102912423tactions
talions7314113_talions
tarnations1038903tarnations
taxations1636863taxations
tenacious1146423tenacious
tensions8310223ten_sions
tevatrons1244003tevatrons
tractions11511623tractions
tuitions838283tuitions
unction9310663unction_
unions64216753un__ions
urinations10310693urinations
vacations141910553vacations
venditions1445523venditions
venerations14411313venerations
venetians1244673venetians
vernation12311083vernation_
vexation1838783vexation_
vexatious1944103vexatious
vocations141911423vocations
wanions104011373_wanions
wantons103713013want_ons
zeatins16311733zeati_ns
zonation171410723zonation_

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.406440125.6
2DLD Change Limit1461623576.79621507.1
3Display Results3573570.1562288.5
 (SQL Overall)1786913577.35824285.3
 
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.