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

313 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
aeration831993(None) 
aerations9317901aerations
aberration1267202aberration
ablation10312432ablation
abrasion1046622abrasion
adnation9310782adnation
adoration10311312adoration
aerating92821002aerating
aerator7314842aerat_or
agnation9311722agnation
alation72920552a_lation
alteration10612902alteration
aviation11312742aviation
ceratin93020162cerati_n
creation102816512creation
deaeration11313012deaeration
delation92318082delation
duration9312692duration
elation73620452_elation
enation73419232_enation
erasion7311962_erasion
fetation11613142fetation
gelation93014432gelation
gyration1237762gyration
iteration9515032iteration
keratin113314152kerati_n
laceration1249572laceration
legation92412932legation
maceration1449612maceration
narration9310062narration
negation92913022negation
nervation12610242nervation
operation11314002operation
oration71617712_oration
ration64226012__ration
relation82619772relation
sedation9312452sedation
seriation9318062seriation
serration9414072serration
venation11513502venation
vernation12311082vernation
vexation1838782vexation
aberrations1346693aberrations
abjuration1945883abjuration
ablations11311513ablations
ablution1047223ablution
abnegation1345413abnegation
abortion1048103abortion
abrasions1145813abrasions
abreaction1444653abreaction
abrogation13107333abrogation
abruption1343973abruption
accretion1345933accretion
acrasin9311223acrasi_n
acromion1246063acromion
action84719683a__ction
actuation11310333actuation
acylation1448653acylation
adaption1145643adaption
addition1096893addition
ademption1443493ademption
adjuration1845523adjuration
admiration1347733admiration
adnations1039753adnations
adoption1146083adoption
adorations11310233adorations
adulation10311013adulation
aerate64830553aerat__e
aerated85322373aerat_ed
aerates74627493aerat_es
aerators8315613aerators
agitation10311223agitation
agnations10310033agnations
agrarian948253agrarian
alations82518893a_lations
alienation1048793alienation
allegation1146813allegation
alterations11511663alterations
altercation1347013altercation
alternation1147623alternation
ambition1246563ambition
amotion9710473a_motion
animation11313683animation
annexation1744953annexation
arcuation11410583arcuation
arraign845063arra_ign
arrogation11107443arrogation
aspiration1249993aspiration
assertion946723asser_tion
attraction1276953attraction
attrition966963attrition
auction93412933a_uction
audition979173audition
aversion1147313aver_sion
aviations12311553aviations
avocation14168993avocation
berating113220763berating
betatron1045233betatron
bevatron1343883bevatron
carnation11312943carnation
caseation1199513caseation
cassation1197913cassation
castration12410803castration
catenation1249523catenation
cation83925503__cation
caudation1269993caudation
causation1199523causation
ceratins102818733ceratins
ceratoid1149923ceratoid
certain92612213certai_n
cessation1176853cessation
chelation1439963chelation
citation10314363citation
conation101420883conation
craton84517193_crat_on
creatin93618133creati_n
creations112614543creations
cremation13511643cremation
crenation11412923crenation
damnation1238403damnation
darnation1039823darnation
deaerations12311673deaerations
dealation10313003dealation
decoration13314423decoration
deflation13310653deflation
delations102616593delations
deletion92011973deletion
demotion1169073demotion
dentation10315243dentation
deraign936573dera_ign
derating103222283derating
derision939073derision
derivation14712783derivation
derogation12410393derogation
detraction13138583detraction
detrition1049133detrition
deviation13312393deviation
devotion1256763devotion
dilation92215463dilation
donation91513783donation
dotation91412733dotation
durations10311463durations
edition8310853_edition
elations83719123_elations
elevation1239233elevation
elution72913823_elution
emotion9711303_emotion
enations83316903_enations
enervation1369473enervation
equation17310483equation
erasions8310983_erasions
erection102115513_erection
erosion7311113_erosion
eruption1047043_eruption
evasion1036753_evasion
exaction1738953_exaction
execration1949833execration
exertion15310083exer_tion
federation1449573federation
fellation1238843fellation
fermion1236763fer_mion
fetations12511383fetations
fixation1837073fixation
formation1439423formation
fraction1359483_fraction
furcation1448353furcation
gelatin83514733gelati_n
gelations102513093gelations
gemmation1445963gemmation
generation11312423generation
geraniol945143geraniol
gestation10310663gestation
gratin74520583_grati_n
gyrations1336923gyrations
haematin13148893haemati_n
halation11313853halation
hematin121516023hemati_n
herniation1348443herniation
himation1339753himation
hydration1646073hydration
ideation9310493ideation
illation8311943illation
iodation9310383iodation
iterations10413823iterations
jactation1838143jactation
kation104315683__kation
keratins122313483keratins
keratoid1347273keratoid
lacerations1348333lacerations
lactation11310813lactation
lallation939493lallation
laudation1088133laudation
laureation1046153laureation
lavation1139973lavation
laxation1538423laxation
lection92614863le_ction
legations102711923legations
lenition8310083lenition
libation102411363libation
liberation1269993liberation
libration111510163libration
ligation92313093ligation
literation10511413literation
lobation102110553lobation
location102113913location
lunation8311923lunation
luxation1538233luxation
macerations1548473macerations
marathon1346823marathon
maturation1249513maturation
mediation12312293mediation
megaton10269853megat_on
mentation11313983mentation
mention9314373me_ntion
migration12179703migration
moderation1348653moderation
mutation101412883mutation
narrations1038943narrations
natation81513933natation
nation64322803__nation
negations102811963negations
negaton8299143negat_on
negatron9335993negatron
nervations1359483nervations
nidation9410583nidation
nitration9313443nitration
notation81414603notation
novation111710013novation
numeration12137963numeration
nutation81513103nutation
oblation1039863oblation
operations12312953operations
orations81515803_orations
ovation101510023_ovation
overaction1547993overaction
palmation13310223palmation
palpation1339073palpation
parathion1446173parathion
peltation11312963peltation
perdition1249013perdition
pereion9312053per_eion
permeation14410563permeation
peroration12316003peroration
pertain92714963pertai_n
pervasion1446073pervasion
petition10711753petition
portion9615493por_tion
potation101716783potation
predation12313463predation
proration11415983proration
pupation1269503pupation
purgation1247393purgation
radiation10313393radiation
ratio55227583__ratio_
rations74123433__rations
ratios64922673__ratios
ratoon64417373__ratoon
ratton64116123__ratton
reaction10612603reaction
recaution1148093recaution
recreation12413613recreation
redaction1259663redaction
reflation12412333reflation
refraction15137903refraction
relations92418333relations
remotion10410233remotion
reparation12612723reparation
restation9316913restation
retraction121310533retraction
rogation91612053rogation
rotation81615453rotation
saltation9312003saltation
salvation1239293salvation
satiation9313433satiation
saturation1049803saturation
secretion11118303secretion
section92515663se_ction
sedations10311253sedations
sedition939333sedition
sensation9510583sensation
separation12510433separation
seriations10316683seriations
serrations10313103serrations
solation8916153solation
sorption1037513sorption
station72717243_station
striation9313483striation
sudation9310803sudation
tarnation9310093tarnation
taxation1537993taxation
teratism10312173teratism
teratoid9411073teratoid
ternion739493ter_nion
tertian7511193ter_tian
tevatron1143973tevatron
titration9310543titration
toleration1048963toleration
traction10412683_traction
ulceration1247263ulceration
vacation131911893vacation
vallation1239753vallation
valuation1249973valuation
variation12312393variation
venations12311723venations
veneration13412343veneration
veratrin1147703veratrin
vernations13310333vernations
version10310923ver_sion
vexations1937753vexations
vibration14138203vibration
vocation132311983vocation
zeatin15412823ze_ati_n
zonation171410723zonation

Search took 9 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.440406115.9
2DLD Change Limit1461623138.28017652.4
3Display Results3133130.1262484.1
 (SQL Overall)1786913138.84620200.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.