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

309 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
aerations931790(None) 
aeration8319931aeration_
aberrations1346692aberrations
ablations11311502ablations
abrasions1145802abrasions
adnations1039752adnations
adorations11310232adorations
aerating92821002aerati_ng
aerators8315612aerat_ors
agnations10310032agnations
alations82518892a_lations
alterations11511662alterations
aviations12311552aviations
ceratins102818732cerati_ns
creations112614542creations
deaerations12311672deaerations
delations102616592delations
durations10311462durations
elations83719122_elations
enations83316902_enations
erasions8310982_erasions
fetations12511382fetations
gelations102513092gelations
gyrations1336922gyrations
iterations10413822iterations
keratins122313482kerati_ns
lacerations1348332lacerations
legations102711922legations
macerations1548472macerations
narrations1038942narrations
negations102811962negations
nervations1359482nervations
operations12312952operations
orations81515802_orations
rations74123432__rations
relations92418332relations
sedations10311252sedations
seriations10316682seriations
serrations10313092serrations
venations12311722venations
vernations13310332vernations
vexations1937752vexations
aberration1267203aberration_
abjurations2045143abjurations
ablation10312433ablation_
ablutions1146593ablutions
abnegations1444923abnegations
abortions1147783abortions
abrasion1046623abrasion_
abreactions1544193abreactions
abrogations14116463abrogations
abruptions1443843abruptions
accretions1444923accretions
acrasins1039973acrasi_ns
actions94218513a__ctions
actuations1239293actuations
acylations1547603acylations
adaptions1245223adaptions
additions1186333additions
ademptions1543383ademptions
adjurations1944823adjurations
admirations1446693admirations
adnation9310783adnation_
adoptions1245783adoptions
adoration10311313adoration_
adulations11310123adulations
aerates74627493aerat__es
aerator7314843aerat_o_r
agitations11310063agitations
agnation9311723agnation_
agrarians1045793agrarians
alation72920553a_lation_
alienations1147883alienations
allegations1246043allegations
alteration10612903alteration_
altercations1446373altercations
alternations1246773alternations
ambitions1346343ambitions
amotions1069843a_motions
animations12312193animations
annexations1844263annexations
arcuations1249343arcuations
arraigns944353arra_igns
arrogations12126483arrogations
aspirations1348993aspirations
assertions1046583asser_tions
attractions1376403attractions
attritions1066793attritions
auctions104012143a_uctions
auditions1078753auditions
aversions1247053aver_sions
aviation11312743aviation_
avocations15168683avocations
berating113220763berati_ng
betatrons1145083betatrons
bevatrons1443713bevatrons
carnations12311353carnations
caseations1258303caseations
cassations1276873cassations
castrations13410053castrations
catenations1348363catenations
cations94524143__cations
caudations13108223caudations
causations1268143causations
ceratin93020163cerati_n_
cessations1256473cessations
chelations1539073chelations
citations11312503citations
conations111318903conations
cratons94316033_crat_ons
creatins103617513creati_ns
creation102816513creation_
cremations14410713cremations
crenations12511693crenations
damnations1337083damnations
darnations1138413darnations
deaeration11313013deaeration_
dealations11311373dealations
decorations14312883decorations
deflations1439713deflations
delation92318083delation_
deletions102610933deletions
demotions1258443demotions
dentations11413633dentations
deraigns1034883dera_igns
derating103222283derati_ng
derisions1038843derisions
derivations15611493derivations
derogations1349393derogations
detractions14118273detractions
detritions1148953detritions
deviations14311163deviations
devotions1356593devotions
dilations102614453dilations
donations101112353donations
dotations101411633dotations
duration9312693duration_
editions9310403_editions
elation73620453_elation_
elevations1338633elevations
elutions82513053_elutions
emotions10610283_emotions
enation73419233_enation_
enervations1478573enervations
equations1839493equations
erasion7311963_erasion_
erections112515213_erections
erosions8310343_erosions
eruptions1146763_eruptions
evasions1136543_evasions
exactions1838923_exactions
execrations2048923execrations
exertions1639763exer_tions
federations1548883federations
fellations1338063fellations
fermions1336203fer_mions
fetation11613143fetation_
fixations1936353fixations
formations1538203formations
fractions1449103_fractions
furcations1547533furcations
gelatins93414093gelati_ns
gelation93014433gelation_
gemmations1545003gemmations
generations12311423generations
geraniols1044743geraniols
gestations1139773gestations
gratins84119183_grati_ns
gyration1237763gyration_
haematins14147743haemati_ns
halations12312393halations
hematins131714673hemati_ns
herniations1447403herniations
himations1438803himations
hydrations1745273hydrations
ideations1039903ideations
illations9311393illations
iodations1039113iodations
iteration9515033iteration_
jactations1936893jactations
kations114013663__kations
keratin113314153kerati_n_
keratinous1443573keratinous
keratitis1345873keratitis
laceration1249573laceration_
lactations1239423lactations
lallations1038743lallations
laudations1146843laudations
laureations1145573laureations
lavations1238973lavations
laxations1637623laxations
lections102413843le_ctions
legation92412933legation_
lenitions939473lenitions
libations112510443libations
liberations1358943liberations
librations12149063librations
ligations102111993ligations
literations11610583literations
lobations11219613lobations
locations112512743locations
lunations9310723lunations
luxations1637273luxations
maceration1449613maceration_
marathons1446413marathons
maturations1348443maturations
mediations13310983mediations
megatons11279703megat_ons
mentations12312583mentations
mentions10312893me_ntions
migrations13168683migrations
moderations1448273moderations
mutations111211453mutations
narration9310063narration_
natations91412493natations
nations74720563__nations
negation92913023negation_
negatons9299273negat_ons
negatrons10275843negatrons
nervation12610243nervation_
nidations1039213nidations
nitrations10312033nitrations
notations91512973notations
novations12139003novations
numerations13127293numerations
nutations91411763nutations
oblations1139363oblations
operation11314003operation_
oration71617713_oration_
ovations11149263_ovations
overactions1648213overactions
palmations1438733palmations
palpations1437653palpations
parathions1545323parathions
peltations12311553peltations
perditions1348873perditions
pereions10310853per_eions
permeations1549883permeations
perorations13314063perorations
pertains102113423pertai_ns
pervasions1545663pervasions
petitions11511083petitions
portions10514413por_tions
potations111615073potations
predations13812153predations
prorations12314463prorations
pupations1338123pupations
purgations1346743purgations
radiations11311923radiations
ration64226013__ration_
ratios64922673__ratio_s
ratoons73815473__ratoons
rattons73815323__rattons
reactions11711713reactions
recautions1247813recautions
recreations13412253recreations
redactions1359133redactions
reflations13311233reflations
refractions16127723refractions
relation82619773relation_
remotions1149703remotions
reparations13611663reparations
restations10315843restations
retractions13910353retractions
rogations101510823rogations
rotations91613843rotations
saltations10310623saltations
salvations1338133salvations
satiations10312113satiations
saturations1148573saturations
secretions12117843secretions
sections102714703se_ctions
sedation9312453sedation_
seditions1039013seditions
sensations1059853sensations
separations1369273separations
seriation9318063seriation_
serration9414063serration_
solations9814623solations
sorptions1137123sorptions
stations82415223_stations
striations10312793striations
sudations1039903sudations
tarnations1038903tarnations
taxations1636863taxations
teratisms11410073teratisms
ternions838813ter_nions
tertians839103ter_tians
tevatrons1244003tevatrons
titrations1039173titrations
tolerations1158133tolerations
tractions11511623_tractions
ulcerations1346363ulcerations
vacations141910553vacations
vallations1339083vallations
valuations1348783valuations
variations13310773variations
venation11513503venation_
venerations14411313venerations
veracious1447123veracious
veratrins1247753veratrins
vernation12311083vernation_
versions11310353ver_sions
vexation1838783vexation_
vexatious1944103vexatious
vibrations15157373vibrations
vocations141911423vocations
zeatins16311733ze_ati_ns
zonations18139313zonations

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486413098.18618158.0
3Display Results3093090.1561980.8
 (SQL Overall)1786913098.49821027.4
 
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.