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

434 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
elation7362045(None) 
alation72920551alation
delation92318081delation
elations83719121elations
elution72913821elution
enation73419231enation
gelation93014431gelation
relation82619771relation
ablation10312432ablation
aeration8319932aeration
alations82518892alations
cation83925502_cation
chelation1439962chelation
clarion9311662clarion
dealation10313002dealation
deflation13310652deflation
delations102616592delations
deletion92011972deletion
dilation92215462dilation
edition8310852edition
elain55324702ela_i_n
elastin72611842elasti_n
elating83423082elating
elative10312452elative
election102015352election
elevation1239232elevation
elision72311102elision
elusion72310952elusion
elutions82513052elutions
elytron1045462elytron
emotion9711302emotion
emulation11312392emulation
enations83316902enations
epilation11312962epilation
equation17310482equation
erasion7311962erasion
evasion1036752evasion
exaction1738952exaction
fellation1238842fellation
fetation11613142fetation
flatiron1144622flatiron
gelatin83514732gelati_n
gelations102513092gelations
halation11313852halation
illation8311942illation
kation104315682_kation
latino64120472_latino
lection92614862lection
legation92412932legation
lotion65716522_lotion
nation64322802_nation
negation92913022negation
oblation1039862oblation
oration71617712oration
ovation101510022ovation
peltation11312962peltation
platoon938952platoon
ration64226012_ration
reflation12412332reflation
relations92418332relations
sedation9312452sedation
solation8916152solation
station72717242station
venation11513502venation
vexation1838782vexation
ablations11311513ablations
ablution1047223ablution
action84719683_action
acylation1448653acylation
adaption1145643adaption
adnation9310783adnation
adulation10311013adulation
aerations9317903aerations
agnation9311723agnation
alanin6317273alani_n
amotion9710473amotion
anion55028813__anion
auction93412933auction
aviation11312743aviation
avion84218343__avion
axion1211316913__axion
basion84315853_basion
bastion9312473bastion
baton75822423_bat_on
betatron1045223betatron
bevatron1343883bevatron
blain75421793bla_i_n
blazon1736763bla_zon
camion103917193_camion
caption113513693caption
cations94524143_cations
caution93013523caution
celadon1036913cela_don
ceratin93020163cerati_n
cessation1176853cessation
chelations1539073chelations
ciliation111112493ciliation
citation10314363citation
clarions10310493clarions
classon937693classon
clavation1447003clavation
claxon1536583cla_xon
coaction12310773coaction
coition9314313coition
collation11313993collation
conation101420883conation
craton84517193crat_on
creation102816513creation
cremation13511643cremation
crenation11412923crenation
dalton7311273dalt_on
dealations11311373dealations
deflations1439713deflations
delating103119603delating
delator83015023delat_or
delegation1238883delegation
deletions102610933deletions
delusion937433delusion
demotion1169073demotion
dentation10315243dentation
depilation13312033depilation
depletion1256663depletion
desolation11311403desolation
deviation13312393deviation
devotion1256763devotion
diatron839283diatron
diction102313053diction
dilations102614453dilations
dilution9239143dilution
donation91513783donation
dotation91412733dotation
duration9312693duration
eaten55323053e_at_en
eating75134403e_ating
eclosion1046893eclosion
editions9310403editions
education12310203education
eduction1169053eduction
egestion946863egestion
ejection172510043ejection
elains64919853ela_ins
elan46734243ela___n
elapid939543elapi_d
elapids1036503elapids
elapine9310673elapine
elastic93013393elasti_c
elastics102710883elastics
elastins82111743elastins
elate55335883elat__e
elated74725823elat_ed
elater64724203elat_er
elaterin849903elaterin
elaters74420193elaters
elates65032363elat_es
elatives1139783elatives
elections112414973elections
electron102611413electron
elevations1338633elevations
elevon977953el_evon
elfin84312463el_fi_n
elisions82210423elisions
elitism939763elitism
elitist7414913elitist
elocution1145673elocution
eloign7456983el_oign
eloin55923203el_oi_n
elongation1145353elongation
elusions82610083elusions
eluting84115293eluting
eluviation1376613eluviation
elysian1065083elysian
emanation11910783emanation
emetin8613463emeti_n
emoticon1273793emoticon
emotions10610283emotions
emulations12310943emulations
enatic8317563enati_c
epilations12311713epilations
equations1839493equations
erasions8310983erasions
erection102115513erection
erosion7311113erosion
eruption1047043eruption
escalation1248873escalation
etalon648973eta_lon
etamin81311853etami_n
etatism9610293etatism
etatist7415033etatist
ethion938813e_thion
etiolation1048533etiolation
eulachon1353003eulachon
evaluation1358183evaluation
evasions1136543evasions
evection131910833evection
eviction13228683eviction
evocation142010293evocation
evolution12117093evolution
exactions1838923exactions
exaltation1748493exaltation
exciton1646083exciton
exertion15310083exertion
exhalation2046653exhalation
expiation18710423expiation
exudation1787693exudation
exultation1747533exultation
faction122613333faction
fanion94514323_fanion
fellatio1145683fellatio_
fellations1338063fellations
fellatios1245503fellatios
fetations12511383fetations
fiction122010733fiction
filiation121110243filiation
fixation1837073fixation
flacon1138633fla_con
flagon1037983fla_gon
flatirons1244483flatirons
flatlong12274523flatlong
flatten10429653flatten
flattop1244403flattop
flavin1239303flavi_n
flection13239563flection
flexion1735073flexion
flotation1267813flotation
fluxion1735043fluxion
foliation121110793foliation
fraction1359483fraction
gabion93211033_gabion
gelati73814533gelati__
gelatine93213303gelatine
gelating103015733gelating
gelatins93414093gelatins
gelatis83313513gelati_s
gelato73812953gelat_o_
gelatos83111513gelat_os
gemmation1445963gemmation
gestation10310663gestation
glutton844893glutton
gnathion1243443gnathion
gratin74520583grati_n
gyration1237763gyration
halations12312393halations
hellion10311133hel_lion
hematin121516023hemati_n
himation1339753himation
ideation9310493ideation
illations9311393illations
inaction1039623inaction
inflation12311093inflation
iodation9310383iodation
isatin6412213isati_n
isolation9311643isolation
iteration9515033iteration
kations114013663_kations
keratin113314153kerati_n
klaxon1733853kla_xon
ladino73615123_ladino
ladron73413323_ladron
lagoon7410483_lagoon
lain46146283_la_i_n
lallation939493lallation
lampion11278303_lampion
lapin75222923_lapi_n
lardon74415063_lardon
lateen64014863_lateen
laten54328343_lat_en
lati46438273_lati__
latigo73410013_latigo
latigos8277243_latigos
latina65621143_latina
latinos73613803_latinos
latish92416173_latish
latten65018203_latten
lattin64316223_lattin
lavation1139973lavation
laxation1538423laxation
layin84720333_layi_n
lectin82515013lecti_n
lections102413843lections
legations102711923legations
legion75712983_legion
lenition8310083lenition
leptin82512333lepti_n
lepton82510803lept_on
lesion64715063_lesion
libation102411363libation
ligation92313093ligation
lion46334443_l__ion
lobation102110553lobation
location102113913location
logion76013723_logion
lotions74614763_lotions
lunation8311923lunation
luxation1538233luxation
malathion1444513malathion
matin75132853_mati_n
matron83918313_matron
mediation12312293mediation
megaton10269853megat_on
melanian1048483melanian
melanin9310893melani_n
melton8311553mel_t_on
mentation11313983mentation
mention9314373mention
motion85217553_motion
mutation101412883mutation
nasion63914083_nasion
natation81513933natation
nations74720563_nations
natron64116023_natron
negations102811963negations
negaton8299143negat_on
negatron9335993negatron
nervation12610243nervation
nidation9410583nidation
notation81414603notation
notion64516583_notion
novation111710013novation
nutation81513103nutation
oblations1139373oblations
olfaction1464233olfaction
operation11314003operation
option83612713_option
orations81515803orations
ovations11149263ovations
ovulation1238983ovulation
paction112713963paction
palmation13310223palmation
palpation1339073palpation
patin76832853_pati_n
patio74426353_patio_
patios85221783_patios
patron84018043_patron
peculation14311993peculation
peloton938743pelot_on
peltations12311553peltations
petition10711753petition
placation1339773placation
plain74823303pla_i_n
planation11310123planation
plasmon11257983plasmon
plastron1046913plastron
platan83913693plat_an
platen84518203plat_en
platier93716293platier
platies93722543platies
platina94413643platina
plating103823073plating
platoons1038683platoons
plication13311683plication
plosion939113plosion
pluton838853plut_on
portion9615493portion
potation101716783potation
potion84519573_potion
predation12313463predation
pulsation1137143pulsation
pupation1269503pupation
ratio55227583_ratio_
rations74123433_rations
ratios64922673_ratios
ratoon64417373_ratoon
ratton64116123_ratton
reaction10612603reaction
recaution1148093recaution
redaction1259663redaction
reflations13311233reflations
regulation11312053regulation
relating92725443relating
relational1047713relational
relative11313143relative
relator74016363relat_or
relaxation1746453relaxation
relaxin14239183relaxi_n
relegation11610023relegation
reliction11310693reliction
religion996743religion
relocation12312113relocation
remotion10410233remotion
repletion1147693repletion
restation9316913restation
revelation13410923revelation
rogation91612053rogation
rotation81615453rotation
ruction93611613ruction
saltation9312003saltation
salvation1239293salvation
satin55935223_sati_n
scalation11311073scalation
section92515663section
sedations10311253sedations
sedition939333sedition
selection11311273selection
sensation9510583sensation
seriation9318063seriation
serration9414063serration
siltation939213siltation
slain54923573sla_i_n
slatier74016813slatier
slating83724653slating
solations9814623solations
solution889593solution
solvation1237773solvation
statin63921473stati_n
stations82415223stations
suasion739363suasion
sublation11311013sublation
suction93713043suction
sudation9310803sudation
sulcation11710733sulcation
sulfation1288783sulfation
taction93213023taction
talion6317713_talion
taxation1537993taxation
telamon936523tela_mon
telethon1145993telethon
tevatron1143973tevatron
traction10412683traction
tuition738823tuition
ululation938093ululation
unction9310663unction
vacation131911893vacation
vallation1239743vallation
valuation1249973valuation
venations12311723venations
vernation12311083vernation
vexations1937753vexations
violation1238443violation
vocation132311983vocation
volition1179173volition
volution1198603volution
wanion93213063_wanion
zeatin15412823zeati_n
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 Filter1786911340270.406440125.6
2DLD Change Limit1340274346.48320673.6
3Display Results4344340.1732508.7
 (SQL Overall)1786914347.06225303.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.