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

409 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
alations8251889(None) 
ablations11311511ablations
alation72920551alation_
elations83719121elations
halations12312391halations
ablation10312432ablation_
ablutions1146602ablutions
actions94218512a_ctions
acylations1547602acylations
adaptions1245222adaptions
adnations1039752adnations
adulations11310122adulations
aerations9317902aerations
agnations10310032agnations
alanins7315802alani_ns
amotions1069842amotions
auctions104012142auctions
aviations12311552aviations
cations94524142_cations
clarions10310492clarions
dealations11311372dealations
delations102616592delations
dilations102614452dilations
elation73620452elation_
elutions82513052elutions
enations83316902enations
flatirons1244482flatirons
gelations102513092gelations
halation11313852halation_
illations9311392illations
kations114013662_kations
lallations1038742lallations
latinos73613802_latinos
lavations1238972lavations
laxations1637622laxations
lotions74614762_lotions
malathions1543872malathions
natations91412492natations
nations74720562_nations
oblations1139372oblations
orations81515802orations
ovations11149262ovations
palmations1438732palmations
palpations1437652palpations
platoons1038682platoons
rations74123432_rations
relations92418332relations
saltations10310622saltations
salvations1338132salvations
scalations1239782scalations
solations9814622solations
stations82415222stations
taxations1636862taxations
vacations141910552vacations
vallations1339092vallations
valuations1348782valuations
abandons1145353abandons
abating10413973abati_ng
abatis84317933abati__s
abatises10311013abatises
abators94413093abat_ors
ablating11312003ablati_ng
ablatives1445503ablatives
ablators1069883ablat_ors
ablution1047223ablution_
abolitions1246653abolitions
abortions1147783abortions
abrasions1145813abrasions
abutilons1142963abutilons
acetins9313173aceti_ns
actinons10389453a_ctinons
actins86321103a_cti_ns
action84719683a_ction_
actuations1239293actuations
acylation1448653acylation_
adagios945513adagio_s
adaption1145643adaption_
additions1186333additions
adnation9310783adnation_
adoptions1245783adoptions
adorations11310233adorations
adulation10311013adulation_
aeration8319933aeration_
agatizes1838863agatizes
agitations11310063agitations
agnation9311723agnation_
alamos8415003ala_mo_s
alanin6317273alani_n_
alanine7316863alani_ne
alanines8314803alanines
alans55636173ala___ns
alastors8311223alastors
alates64833973alat__es
albatross1142573albatross
albinos937653al_binos
aldrins8310203aldri_ns
alencons1045483alencons
aleurons867013aleurons
alevins102110573alevi_ns
alexins141910663alexi_ns
algins74816433al_gi_ns
alienations1147883alienations
aliens65619213al__iens
aligns75312953al__igns
alkylations1843353alkylations
allantoins1083723allantoins
allegations1246043allegations
allocations1347773allocations
allusions946013allusions
alluvions1254373alluvions
aloins65022203al_oi_ns
alterations11511663alterations
althorns1146733al_thorns
altos55822953al_t_o_s
alumins9512983alumi_ns
amatols938183amat_ols
amazons1836653ama_zons
ambitions1346343ambitions
ambulations1547113ambulations
amnions93710913a_mnions
amotion9710473amotion_
anattos7138453anatto_s
angulations1268053angulations
animations12312193animations
anions64123033__anions
annulations1167833annulations
antlions839193antlions
apatites10311293apatites
arcuations1249343arcuations
attains7310983attai_ns
auction93412933auction_
auditions1078753auditions
aviation11312743aviation_
avions94114393__avions
avocations15168683avocations
axions134713483__axions
basions94213953_basions
bastions10411693bastions
batons85519423_bat_ons
blains84516373bla_i_ns
blazons1836163bla_zons
calathos1347533calatho_s
calutrons1145503calutrons
camions113916133_camions
captions123813223captions
carnations12311353carnations
caseations1258303caseations
cassations1276873cassations
cation83925503_cation_
caudations13108223caudations
causations1268143causations
cautions103313183cautions
chalazions24113323chalazions
chelations1539073chelations
ciliations121111003ciliations
citations11312503citations
clarion9311663clarion_
classons1037703classons
clavations1546183clavations
claxons1635803cla_xons
coactions1349743coactions
coalitions1247923coalitions
coitions10312853coitions
collations12312853collations
conations111318903conations
cratons94316033crat_ons
creations112614543creations
dalapons1145443dala_pons
dalmatians1343563dalmatians
daltons8310403dal_t_ons
damnations1337083damnations
darnations1138413darnations
dealation10313003dealation_
deflations1439713deflations
delation92318083delation_
deletions102610933deletions
diatrons939613diatrons
dictions111812673dictions
dilation92215463dilation_
dilutions10248583dilutions
donations101112353donations
dotations101411633dotations
durations10311463durations
editions9310403editions
elains64919853ela_i_ns
elastins82111743elasti_ns
elating83423083elati_ng
elatives1139783elatives
elections112414973elections
elevations1338633elevations
elisions82210423elisions
elusions82610083elusions
elution72913823elution_
emanations1289593emanations
emotions10610283emotions
emulations12310943emulations
enation73419233enation_
epilations12311713epilations
equations1839493equations
erasions8310983erasions
escalations1347663escalations
evaluations1457323evaluations
evasions1136543evasions
exactions1838923exactions
exaltations1847293exaltations
exhalations2146023exhalations
factions133013063factions
falchions1743913falchions
fanions103713073_fanions
fellations1338063fellations
fetations12511383fetations
fictions132410743fictions
filiations13119093filiations
fixations1936353fixations
flacons1238053fla_cons
flagons1137973fla_gons
flatiron1144623flatiron_
flatlong12274523flatlong
flattens11357483flattens
flattops1344553flattops
flavins1338543flavi_ns
flections14239213flections
flexions1844413flexions
flotations1366873flotations
fluxions1844423fluxions
foliations1399943foliations
fractions1449103fractions
gabions102410053_gabions
gelatins93414093gelati_ns
gelation93014433gelation_
gluttons944273gluttons
gnathions1343303gnathions
gradations1286863gradations
gratins84119183grati_ns
gyrations1336923gyrations
himations1438803himations
ideations1039903ideations
illation8311943illation_
inactions1139323inactions
inflations13310323inflations
inhalations14126743inhalations
iodations1039113iodations
isatins7310773isati_ns
isolations10310693isolations
jactations1936893jactations
jalapins1745623jalapi_ns
kation104315683_kation_
klaxons1833263kla_xons
lactations1239423lactations
ladinos8389963_ladinos
ladrons83813193_ladrons
lagoons839253_lagoons
lallation939493lallation_
lampions12277973lampions
lapins84520683_lapi_ns
lardons83914493_lardons
lateens74210553_lateens
latens64620213_lat_ens
latices9313763_latices
latigoes9306163_latigoes
latigos8277243_latigos
latina65621143_lati_na
latinas74416463_latinas
latino64120473_lati_no
lattens75014673_lattens
lattins74115483_lattins
laudations1146843laudations
lavation1139973lavation_
laxation1538423laxation_
layins93817653_layi_ns
lections102413843lections
legations102711923legations
legions84611783_legions
lesions73813873_lesions
libations112510443libations
ligations102111993ligations
lions55923213_l__ions
lobations11219613lobations
locations112512743locations
logions86211293_logions
lotion65716523_lotion_
lunations9310723lunations
luxations1637273luxations
maculations1569623maculations
malarious1147043malarious
malathion1444513malathion_
marathons1446423marathons
matins84527783_mati_ns
matrons93517633_matrons
mentions10312893mentions
motions94215003_motions
mutations111211453mutations
narrations1038943narrations
nasions73112383_nasions
natation81513933natation_
nation64322803_nation_
natrons73215663_natrons
negations102811963negations
nidations1039213nidations
notations91512973notations
notions74014483_notions
novations12139003novations
nutations91411763nutations
oblation1039863oblation_
olfactions1563873olfactions
options93810603_options
oration71617713oration_
ovation101510023ovation_
ovulations1337973ovulations
pactions122613503pactions
paladins11911003paladi_ns
palatine10316073palati_ne
palatines11313043palatines
palliations1347723palliations
palmation13310223palmation_
palpation1339073palpation_
parathions1545323parathions
patins87528783_pati_ns
patios85221783_patio_s
patrons93818103_patrons
peltations12311553peltations
placations1438583placations
plains85019593pla_i_ns
planations1238723planations
plasmons12217663plasmons
plastrons1147133plastrons
platans93413123plat_ans
platens94213983plat_ens
platies93722543plati_es
platina94413643plati_na
platinas103610313platinas
plating103823073plati_ng
platings113611363platings
platinous1146193platinous
platoon938953platoon_
plications14310493plications
plosions1038023plosions
plutons938343plut_ons
portions10514413portions
potations111615073potations
potions93417423_potions
pulsations1236373pulsations
pupations1338123pupations
radiations11311923radiations
ration64226013_ration_
ratios64922673_ratio_s
ratoons73815473_ratoons
rattons73815323_rattons
reactions11711713reactions
reflations13311233reflations
relation82619773relation_
rogations101510823rogations
rotations91613843rotations
ructions102811683ructions
sabatons1037843sabat_ons
sacatons1038973sacat_ons
salacious1147113salacious
salivations1448733salivations
saltation9312003saltation_
salutations1147643salutations
salvation1239293salvation_
sanctions1138873sanctions
satiations10312113satiations
satins64930483_sati_ns
scalation11311073scalation_
sections102714703sections
sedations10311253sedations
siltations1038553siltations
slating83724653slati_ng
slatings94011723slatings
solation8916153solation_
solutions988883solutions
solvations1336833solvations
spallations1356103spallations
statins73719773stati_ns
station72717243station_
suasions838783suasions
sublations12410113sublations
suctions103012903suctions
sudations1039903sudations
sulcations1289583sulcations
sulfations13107813sulfations
tabulations1346853tabulations
tactions102912423tactions
talapoins1144703talapoins
talions7314113_talions
talkathons1792223talkathons
tarnations1038903tarnations
taxation1537993taxation_
tractions11511623tractions
tuitions838283tuitions
ululations1037143ululations
unctions1039733unctions
vacation131911893vacation_
validations1547243validations
vallation1239753vallation_
valuation1249973valuation_
variations13310773variations
venations12311723venations
vexations1937753vexations
violations1337963violations
vocations141911423vocations
volitions1288663volitions
volutions12108393volutions
walkathons2091743walkathons
wanions104011373_wanions
zacatons1945703zacat_ons
zeatins16311733zeati_ns
zonations18139313zonations

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.420425454.8
2DLD Change Limit1461624096.61022112.3
3Display Results4094090.1732364.2
 (SQL Overall)1786914097.20324807.9
 
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.