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

357 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
orations8151580(None) 
oration71617711oration_
ovations11149261ovations
rations74123431_rations
adorations11310232adorations
aerations9317902aerations
alations82518892alations
cations94524142_cations
conations111318902conations
cratons94316032crat_ons
creations112614542creations
donations101112352donations
dotations101411632dotations
durations10311462durations
elations83719122elations
enations83316902enations
erasions8310982erasions
formations1538202formations
fractions1449102fractions
gratins84119182grati_ns
gyrations1336922gyrations
iodations1039112iodations
kations114013662_kations
lobations11219612lobations
locations112512742locations
nations74720562_nations
notations91512972notations
novations12139002novations
oblations1139372oblations
operations12312952operations
options93810602o_ptions
orating83520322orati_ng
orators7313822orat_ors
ovation101510022ovation_
portions10514412por_tions
potations111615072potations
prorations12314462prorations
ration64226012_ration_
ratios64922672_ratio_s
ratoons73815472_ratoons
rattons73815322_rattons
rogations101510822rogations
rotations91613842rotations
solations9814622solations
sorptions1137122sorptions
stations82415222stations
tractions11511622tractions
vocations141911422vocations
zonations18139312zonations
ablations11311513ablations
abortions1147783abor_tions
abrasions1145813abrasions
actions94218513_actions
adaptions1245223adaptions
adnations1039753adnations
adoration10311313adoration_
aeration8319933aeration_
agnations10310033agnations
alation72920553alation_
amotions1069843amotions
anions64123033__anions
arcuations1249343arcuations
auctions104012143auctions
aviations12311553aviations
avions94114393__avions
avocations15168683avocations
axions134713483__axions
basions94213953_basions
bastions10411693bastions
batons85519423_bat_ons
borating113414503borati_ng
bradoons1136763bradoons
brains85125473bra_i_ns
camions113916133_camions
captions123813223captions
carnations12311353carnations
carrions10312453carrions
cartons94122473cart_ons
cartoons104012803cartoons
cation83925503_cation_
cautions103313183cautions
ceratins102818733cerati_ns
citations11312503citations
clarions10310493clarions
coactions1349743coactions
cognations1339593cognations
coitions10312853coitions
collations12312853collations
colorations13911893colorations
conation101420883conation_
connations12312943connations
cooptions13107763cooptions
copatrons1346333copatrons
coronations13410703coronations
corotations1349763corotations
corrasions1246353corrasions
cortins92421333cor_ti_ns
crampons1436643crampons
crating103725203crati_ng
craton84517193crat_on_
crayons12439233cra_yons
creatins103617513creati_ns
creation102816513creation_
cremations14410713cremations
crenations12511693crenations
cretins93216423creti_ns
crotons93714373crot_ons
darnations1138413darnations
decorations14312883decorations
delations102616593delations
diatrons939613diatrons
dictions111812673dictions
dilations102614453dilations
donation91513783donation_
dotation91412733dotation_
dragons938383dra_gons
dragoons1045013dragoons
drains73719403dra_i_ns
duration9312693duration_
editions9310403editions
elation73620453elation_
elutions82513053elutions
emotions10610283emotions
enation73419233enation_
equations1839493equations
erasion7311963erasion_
erections112515213erections
erosions8310343erosions
eruptions1146763eruptions
evasions1136543evasions
evocations15259873evocations
exactions1838923exactions
factions133013063factions
fanions103713073_fanions
fetations12511383fetations
fictions132410743fictions
fixations1936353fixations
flatirons1244483flatirons
floriations1476913floriations
flotations1366873flotations
foliations1399943foliations
formation1439423formation_
fraction1359483fraction_
fractious1456143fractious
frictions1448033frictions
fruitions12106113fruitions
furcations1547533furcations
gabions102410053_gabions
gelations102513093gelations
gnathions1343303gnathions
gracious1138593gracious
gradations1286863gradations
gradins93416233gradi_ns
grains74223093gra_i_ns
gratin74520583grati_n_
gratine84719193grati_ne
grating93923183grati_ng
gratings103910763gratings
gratis74819243grati__s
gravitons1343963gravitons
grunions945353grunions
gyration1237763gyration_
halations12312393halations
himations1438803himations
hydrations1745283hydrations
ideations1039903ideations
illations9311393illations
inactions1139323inactions
iodation9310383iodation_
isatins7310773isati_ns
isolations10310693isolations
iterations10413823iterations
kation104315683_kation_
keratins122313483kerati_ns
latinos73613803_latinos
lavations1238973lavations
laxations1637623laxations
lections102413843lections
legations102711923legations
libations112510443libations
librations12149063librations
ligations102111993ligations
lobation102110553lobation_
location102113913location_
locutions11207063locutions
lotions74614763_lotions
lunations9310723lunations
luxations1637273luxations
marathons1446413marathons
martians103111613martians
martins93322063marti_ns
matins84527783_mati_ns
matrons93517633_matrons
mentions10312893mentions
migrations13168683migrations
moderations1448273moderations
monitions11310883monitions
morions94014643mor__ions
morrions1077673mor_rions
morulations13148163morulations
motions94215003_motions
mutations111211453mutations
narrations1038943narrations
nasions73112383_nasions
natations91412493natations
nation64322803_nation_
natrons73215663_natrons
negations102811963negations
nervations1359483nervations
nidations1039213nidations
nitrations10312033nitrations
nonactions1248373nonactions
notation81414603notation_
notions74014483_notions
novation111710013novation_
nutations91411763nutations
oblation1039863oblation_
obtains939163obtai_ns
obturations13116423obturations
obviations1545463obviations
occasions1344063occasions
octagons1144493octagons
olfactions1563873olfactions
onions64016433o__nions
operation11314003operation_
opinions1045933opinions
option83612713o_ption_
oralisms10610973oralisms
oralists8611803oralists
orates64328613orat__es
orator6314533orat_o_r
oratorios944923oratorio_s
oratory1039403orat_ory
oratress834553oratress
oratrices1145833oratrices
orceins937743orcei_ns
orcins83313433or_ci_ns
ordains879653ordai_ns
ordinations1247993ordinations
organons945583organons
origins8310463origi_ns
orisons7310563or_isons
orlons6411013or__lons
orpins83614163or_pi_ns
orthicons1443423orthicons
ovational1246853ovational
overactions1648213overactions
ovulations1337973ovulations
oxidations1845443oxidations
ozonations1945143ozonations
pactions122613503pactions
parathions1545323parathions
partons94620513part_ons
patins87528783_pati_ns
patios85221783_patio_s
patrons93818103_patrons
perorations13314063perorations
phonations1538313phonations
platoons1038683platoons
portion9615493por_tion_
positions11811503positions
potation101716783potation_
potions93417423_potions
prating103424453prati_ng
predations13812153predations
prions84317783pr__ions
privations15310103privations
proactions1449343proactions
probations14311083probations
pronations12314033pronations
proration11415983proration_
protons93118003prot_ons
pupations1338123pupations
purgations1346743purgations
quotations19146283quotations
racons84319343_ra_cons
racoons93912433_racoons
radians83013823_radians
radios74018673_radio_s
radons74118533_ra_dons
rains55140233_ra_i_ns
rampions12248023_rampions
ramsons939563_ramsons
ratans63819373_rat_ans
ratine65131823_rati_ne
ratines75328583_ratines
rating74938703_rati_ng
ratings84217413_ratings
ratio55227583_ratio__
rational8412543_rational
rationals949943_rationals
rationed9410093_rationed
ratites74920683_ratites
ratlins73615583_ratlins
ratoon64417373_ratoon_
ratos55528763_rat_o_s
rattans73411953_rattans
rattens74213403_rattens
ratton64116123_ratton_
rattoons8327513_rattoons
ravins94622563_ravi_ns
rawins95617623_rawi_ns
rayons94113343_ra_yons
reactions11711713reactions
regions83613473_regions
relations92418333relations
rogation91612053rogation_
ronions73313343_ronions
rotation81615453rotation_
ructions102811683ructions
rutins63818393_ruti_ns
satins64930483_sati_ns
sections102714703sections
sedations10311253sedations
seriations10316683seriations
serrations10313093serrations
solation8916153solation_
solutions988883solutions
solvations1336833solvations
sorption1037513sorption_
sortitions1046423sortitions
statins73719773stati_ns
station72717243station_
striations10312793striations
suasions838783suasions
suctions103012903suctions
sudations1039903sudations
tactions102912423tactions
talions7314113_talions
tarnations1038903tarnations
taxations1636863taxations
titrations1039173titrations
tolerations1158133tolerations
torsions839183tor_sions
tortious839023tor_tious
traction10412683traction_
traditions1147193traditions
trains64725343tra_i_ns
traitors8310793traitors
tritons73814883trit_ons
tuitions838283tuitions
unctions1039733unctions
urinations10310693urinations
vacations141910553vacations
variations13310773variations
venations12311723venations
vernations13310333vernations
vexations1937753vexations
vibrations15157373vibrations
violations1337963violations
vocation132311983vocation_
volitions1288663volitions
volutions12108393volutions
voracious1445503voracious
wanions104011373_wanions
zeatins16311733zeati_ns
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 Filter1786911461620.423422437.4
2DLD Change Limit1461623576.68621860.9
3Display Results3573570.1402550.0
 (SQL Overall)1786913577.24924650.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.