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

420 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
alation7292055(None) 
ablation10312431ablation
alations82518891alations
elation73620451elation
halation11313851halation
ablations11311512ablations
ablution1047222ablution
action84719682a_ction
acylation1448652acylation
adaption1145642adaption
adnation9310782adnation
adulation10311012adulation
aeration8319932aeration
agnation9311722agnation
alanin6317272alani_n
amotion9710472amotion
auction93412932auction
aviation11312742aviation
cation83925502_cation
clarion9311662clarion
dealation10313002dealation
delation92318082delation
dilation92215462dilation
elations83719122elations
elution72913822elution
enation73419232enation
flatiron1144622flatiron
gelation93014432gelation
halations12312392halations
illation8311942illation
kation104315682_kation
lallation939492lallation
latino64120472_latino
lavation1139972lavation
laxation1538422laxation
lotion65716522_lotion
malathion1444512malathion
natation81513932natation
nation64322802_nation
oblation1039862oblation
oration71617712oration
ovation101510022ovation
palmation13310222palmation
palpation1339072palpation
platoon938952platoon
ration64226012_ration
relation82619772relation
saltation9312002saltation
salvation1239292salvation
scalation11311072scalation
solation8916152solation
station72717242station
taxation1537992taxation
vacation131911892vacation
vallation1239752vallation
valuation1249972valuation
abandon1045463abandon
abating10413973abating
abatis84317933abati_s
abator84512713abat_or
ablating11312003ablating
ablative1348243ablative
ablator939843ablat_or
ablutions1146603ablutions
abolition1147053abolition
abortion1048103abortion
abrasion1046623abrasion
abutilon1043083abutilon
acetin8314693aceti_n
actin74922553a_cti_n
actinon9459463a_ctinon
actions94218513a_ctions
actuation11310333actuation
acylations1547603acylations
adagio847673adagio_
adagios945513adagios
adaptions1245223adaptions
addition1096893addition
adnations1039753adnations
adoption1146083adoption
adoration10311313adoration
adulations11310123adulations
aerations9317903aerations
again65218123aga_i_n
agatize1739833agatize
agatoid948623agatoid
agitation10311223agitation
agnations10310033agnations
alamo7418143ala_mo_
alamos8415003ala_mos
alan46844083ala___n
alanine7316863alanine
alanins7315803alanins
alastor739663alastor
alate55340323alat__e
alated75625143alat_ed
alates64833963alat_es
albino839933al_bino
aldrin7311243aldri_n
alencon945733alencon
aleuron757383aleuron
alevin92511513alevi_n
alexin132311483alexi_n
algin65718763al_gi_n
alien56425583al__ien
alienation1048793alienation
align65016503al__ign
alkalin11178183alkali_n
alkylation1743823alkylation
allantoin984533allantoin
allegation1146813allegation
allocation1248573allocation
allusion846573allusion
alluvion1144733alluvion
aloin55227423al_oi_n
alteration10612903alteration
altho86312603al_tho_
althorn1047763al_thorn
alto47831263al_t_o_
altos55822953al_t_os
alumin8513543alumi_n
amain74922913ama_i_n
amative12311733amative
amatol838693amat_ol
amazon1736833ama_zon
ambition1246563ambition
ambulation1447873ambulation
amnion84812053a_mnion
amotions1069843amotions
anatto6139913anatto_
anattos7138453anattos
angulation1149553angulation
animation11313683animation
anion55028813__anion
annulation1068953annulation
antlion7310293antlion
apatite9312963apatite
arcuation11410583arcuation
attain6311753attai_n
auctions104012143auctions
audition979173audition
aviations12311553aviations
avion84218343__avion
avocation14168993avocation
axion1211316913__axion
basion84315853_basion
bastion9312473bastion
baton75822423_bat_on
blain75421793bla_i_n
blazon1736763bla_zon
calathos1347523calathos
calutron1045553calutron
camion103917193_camion
caption113513693caption
carnation11312943carnation
caseation1199513caseation
cassation1197913cassation
cations94524143_cations
caudation1269993caudation
causation1199523causation
caution93013523caution
chalazion23113723chalazion
chelation1439963chelation
ciliation111112493ciliation
citation10314363citation
clarions10310493clarions
classon937693classon
clavation1447003clavation
claxon1536583cla_xon
coaction12310773coaction
coalition1148703coalition
coition9314313coition
collation11313993collation
conation101420883conation
craton84517193crat_on
creation102816513creation
dalapon1044893dala_pon
dalmatian1244643dalmatian
dalton7311273dal_t_on
damnation1238403damnation
darnation1039823darnation
dealations11311373dealations
deflation13310653deflation
delations102616593delations
deletion92011973deletion
diatron839283diatron
diction102313053diction
dilations102614453dilations
dilution9239143dilution
donation91513783donation
dotation91412733dotation
duration9312693duration
edition8310853edition
elain55324703ela_i_n
elastin72611843elasti_n
elating83423083elating
elative10312453elative
election102015353election
elevation1239233elevation
elision72311103elision
elusion72310953elusion
elutions82513053elutions
elytron1045463elytron
emanation11910783emanation
emotion9711303emotion
emulation11312393emulation
enations83316903enations
epilation11312963epilation
equation17310483equation
erasion7311963erasion
escalation1248873escalation
evaluation1358183evaluation
evasion1036753evasion
exaction1738953exaction
exaltation1748493exaltation
exhalation2046653exhalation
faction122613333faction
falchion1644343falchion
fanion94514323_fanion
fellation1238843fellation
fetation11613143fetation
fiction122010733fiction
filiation121110243filiation
fixation1837073fixation
flacon1138633fla_con
flagon1037983fla_gon
flatirons1244483flatirons
flatlong12274523flatlong
flatten10429653flatten
flattop1244403flattop
flavin1239303flavi_n
flection13239563flection
flexion1735073flexion
flotation1267813flotation
fluxion1735043fluxion
foliation121110793foliation
fraction1359483fraction
gabion93211033_gabion
gelatin83514733gelati_n
gelations102513093gelations
glutton844893glutton
gnathion1243443gnathion
gradation11107713gradation
gratin74520583grati_n
gyration1237763gyration
himation1339753himation
ideation9310493ideation
illations9311393illations
inaction1039623inaction
inflation12311093inflation
inhalation13107663inhalation
iodation9310383iodation
isatin6412213isati_n
isolation9311643isolation
jactation1838143jactation
jalapin1645923jalapi_n
kations114013663_kations
klaxon1733853kla_xon
lactation11310813lactation
ladino73615123_ladino
ladron73413323_ladron
lagoon7410483_lagoon
lain46146283_la_i_n
lallations1038743lallations
lampion11278303lampion
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
laudation1088133laudation
lavations1238973lavations
laxations1637623laxations
layin84720333_layi_n
lection92614863lection
legation92412933legation
legion75712983_legion
lesion64715063_lesion
libation102411363libation
ligation92313093ligation
lion46334443_l__ion
lobation102110553lobation
location102113913location
logion76013723_logion
lotions74614763_lotions
lunation8311923lunation
luxation1538233luxation
maculation14510983maculation
malarian10311563malarian
malathions1543873malathions
marathon1346813marathon
matin75132853_mati_n
matron83918313_matron
mention9314373mention
motion85217553_motion
mutation101412883mutation
narration9310063narration
nasion63914083_nasion
natations91412493natations
nations74720563_nations
natron64116023_natron
negation92913023negation
nidation9410583nidation
notation81414603notation
notion64516583_notion
novation111710013novation
nutation81513103nutation
oblations1139373oblations
olfaction1464233olfaction
option83612713_option
orations81515803orations
ovations11149263ovations
ovulation1238983ovulation
paction112713963paction
paladin101011773paladi_n
palatial10410623palatial
palatine10316063palatine
palliation1248503palliation
palmations1438733palmations
palpations1437653palpations
parathion1446173parathion
patin76832853_pati_n
patio74426353_patio_
patios85221783_patios
patron84018043_patron
peltation11312963peltation
placation1339773placation
plain74823303pla_i_n
planation11310123planation
plasmon11257983plasmon
plastron1046913plastron
platan83913693plat_an
platen84518203plat_en
platier93716293platier
platies93722543platies
platina94413643platina
plating103823073plating
platoons1038683platoons
plication13311683plication
plosion939113plosion
pluton838853plut_on
portion9615493portion
potation101716783potation
potion84519573_potion
pulsation1137143pulsation
pupation1269503pupation
radiation10313393radiation
ratio55227583_ratio_
rations74123433_rations
ratios64922673_ratios
ratoon64417373_ratoon
ratton64116123_ratton
reaction10612603reaction
reflation12412333reflation
relations92418333relations
rogation91612053rogation
rotation81615453rotation
ruction93611613ruction
sabaton937713sabat_on
sacaton938993sacat_on
salivation1349813salivation
saltations10310623saltations
salutation1048903salutation
salvations1338133salvations
sanction1049533sanction
satiation9313433satiation
satin55935223_sati_n
scalations1239783scalations
section92515663section
sedation9312453sedation
siltation939213siltation
slain54923573sla_i_n
slatier74016813slatier
slating83724653slating
solations9814623solations
solution889593solution
solvation1237773solvation
spallation1247023spallation
statin63921473stati_n
stations82415223stations
suasion739363suasion
sublation11311013sublation
suction93713043suction
sudation9310803sudation
sulcation11710733sulcation
sulfation1288783sulfation
tabulation1247813tabulation
taction93213023taction
talapoin1045013talapoin
talion6317713_talion
talkathon1692423talkathon
tarnation9310093tarnation
taxations1636863taxations
traction10412683traction
tuition738823tuition
ululation938093ululation
unction9310663unction
vacations141910553vacations
validation1448413validation
vallations1339093vallations
valuations1348783valuations
variation12312393variation
venation11513503venation
vexation1838783vexation
violation1238443violation
vocation132311983vocation
volition1179173volition
volution1198603volution
walkathon1991853walkathon
wanion93213063_wanion
zacaton1845633zacat_on
zeatin15412823zeati_n
zonation171410723zonation

Search took 7 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 Limit1340274206.18621666.2
3Display Results4204200.1732427.7
 (SQL Overall)1786914206.76526414.0
 
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.