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

361 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
oration7161771(None) 
orations81515791orations
ovation101510021ovation
ration64226011_ration
adoration10311312adoration
aeration8319932aeration
alation72920552alation
cation83925502_cation
conation101420882conation
craton84517192crat_on
creation102816512creation
donation91513782donation
dotation91412732dotation
duration9312692duration
elation73620452elation
enation73419232enation
erasion7311962erasion
formation1439422formation
fraction1359482fraction
gratin74520582grati_n
gyration1237762gyration
iodation9310382iodation
kation104315682_kation
lobation102110552lobation
location102113912location
nation64322802_nation
notation81414602notation
novation111710012novation
oblation1039862oblation
operation11313992operation
option83612712o_ption
orating83520322orating
orator6314532orat_or
ovations11149262ovations
portion9615492por_tion
potation101716782potation
proration11415982proration
ratio55227582_ratio_
rations74123432_rations
ratios64922672_ratios
ratoon64417372_ratoon
ratton64116122_ratton
rogation91612052rogation
rotation81615452rotation
solation8916152solation
sorption1037502sorption
station72717242station
traction10412682traction
vocation132311982vocation
zonation171410722zonation
ablation10312433ablation
abortion1048103abor_tion
abrasion1046623abrasion
action84719683_action
adaption1145643adaption
adnation9310783adnation
adorations11310223adorations
aerations9317903aerations
agnation9311713agnation
alations82518893alations
amotion9710473amotion
anion55028813__anion
arcuation11410583arcuation
auction93412933auction
aviation11312743aviation
avion84218343__avion
avocation14168993avocation
axion1211316913__axion
basion84315853_basion
bastion9312473bastion
baton75822423_bat_on
borating113414503borating
bradoon1037353bradoon
brain76229383bra_i_n
camion103917193_camion
caption113513693caption
carnation11312943carnation
carrion9312673carrion
carton84522663cart_on
cartoon94114463cartoon
cations94524143_cations
caution93013513caution
ceratin93020163cerati_n
citation10314363citation
clarion9311663clarion
coaction12310763coaction
cognation12310753cognation
coition9314313coition
collation11313993collation
coloration12913183coloration
conations111318893conations
connation11314263connation
cooption1288333cooption
copatron1246743copatron
coronation12412053coronation
corotation12410953corotation
corrasion1146473corrasion
cortin82423143cor_ti_n
crampon1336943crampon
crating103725203crating
cratons94316033crat_ons
crayon114110003cra_yon
creatin93618133creati_n
creations112614533creations
cremation13511643cremation
crenation11412923crenation
cretin82917913creti_n
croton84415453crot_on
darnation1039823darnation
decoration13314403decoration
delation92318083delation
diatron839283diatron
diction102313053diction
dilation92215463dilation
donations101112343donations
dotations101411623dotations
dragon838843dra_gon
dragoon935283dragoon
drain65222893dra_i_n
durations10311463durations
edition8310853edition
elations83719123elations
elution72913823elution
emotion9711303emotion
enations83316903enations
equation17310483equation
erasions8310983erasions
erection102115513erection
erosion7311103erosion
eruption1047033eruption
evasion1036753evasion
evocation142010293evocation
exaction1738953exaction
faction122613333faction
fanion94514323_fanion
fetation11613143fetation
fiction122010733fiction
fixation1837073fixation
flatiron1144623flatiron
floriation1367783floriation
flotation1267813flotation
foliation121110793foliation
formations1538193formations
fractions1449103fractions
friction1347913friction
fruition11106103fruition
furcation1448353furcation
gabion93211023_gabion
gelation93014433gelation
gnathion1243443gnathion
gradation11107713gradation
gradin83517483gradi_n
grain65126253gra_i_n
gratify1436113gratify
gratine84719193gratine
grating93923183grating
gratins84119183gratins
gratis74819243grati_s
graviton1244303graviton
grunion835433grunion
gyrations1336923gyrations
halation11313853halation
himation1339743himation
hydration1646073hydration
ideation9310493ideation
illation8311943illation
inaction1039623inaction
iodations1039113iodations
isatin6412213isati_n
isolation9311643isolation
iteration9515033iteration
kations114013663_kations
keratin113314153kerati_n
latino64120473_latino
lavation1139973lavation
laxation1538423laxation
lection92614863lection
legation92412933legation
libation102411363libation
libration111510163libration
ligation92313093ligation
lobations11219613lobations
locations112512743locations
locution10227663locution
lotion65716523_lotion
lunation8311923lunation
luxation1538233luxation
marathon1346813marathon
martian93514683martian
martin84122523marti_n
matin75132853_mati_n
matron83918313_matron
mention9314373mention
migration12179693migration
moderation1348643moderation
monition10311723monition
morion86217733mor__ion
morrion959003mor_rion
morulation12148903morulation
motion85217553_motion
mutation101412883mutation
narration9310063narration
nasion63914083_nasion
natation81513933natation
nations74720563_nations
natron64116023_natron
negation92913023negation
nervation12610243nervation
nidation9410583nidation
nitration9313443nitration
nonaction1149443nonaction
notations91512973notations
notion64516583_notion
novations12139003novations
nutation81513103nutation
oaten55222403o_at_en
oblations1139363oblations
obtain839183obtai_n
obturation1297143obturation
obviation1446093obviation
occasion1244213occasion
octagon1045243octagon
olfaction1464233olfaction
onion54320973o__nion
operations12312933operations
opinion946793opinion
options93810593o_ptions
oralism9513763oralism
oralist7619633oralist
orality101111683orality
orate55133303orat__e
orated74221503orat_ed
orates64328613orat_es
oratorio845633oratorio_
oratorios944923oratorios
orators7313803orators
oratory1039403oratory
oratrix1444523oratrix
orcein838183orcei_n
orcin72716573or_ci_n
ordain7810403ordai_n
ordination1149413ordination
organon845913organon
origin7311033origi_n
orison6411663or_ison
orlon5415003or__lon
orpin73415533or_pi_n
orthicon1343503orthicon
ortho8312293or_tho_
ovarian1037643ovarian
ovational1246853ovational
overaction1547983overaction
ovulation1238983ovulation
oxidation1746323oxidation
ozonation1845673ozonation
paction112713963paction
parathion1446173parathion
parton84720993part_on
patin76832853_pati_n
patio74426353_patio_
patios85221783_patios
patron84018043_patron
peroration12315993peroration
phonation1439393phonation
platoon938953platoon
portions10514393por_tions
position10912183position
potations111615063potations
potion84519573_potion
prating103424453prating
predation12313463predation
prion75119993pr__ion
privation14311173privation
proaction13410103proaction
probation13412183probation
pronation11415703pronation
prorations12314433prorations
proton84318893prot_on
pupation1269503pupation
purgation1247393purgation
quotation18146973quotation
racon75422143_ra_con
racoon83814473_racoon
radian74117273_radian
radio64922493_radio_
radios74018673_radios
radon64620503_ra_don
rain46251733_ra_i_n
rampion11298583_rampion
ramson8310463_ramson
ratan53722663_rat_an
ratify122610043_ratify
ratine65131823_ratine
rating74938703_rating
rational8412543_rational
rationed9410093_rationed
ratite65022423_ratite
ratlin64116523_ratlin
rato45436973_rat_o_
ratoons73815473_ratoons
ratos55528763_rat_os
rattan63613603_rattan
ratten64217383_ratten
rattons73815323_rattons
rattoon7359243_rattoon
ravin85624653_ravi_n
rawin85521473_rawi_n
rayon83815703_ra_yon
reaction10612603reaction
region74614903_region
relation82619773relation
rogations101510823rogations
ronion63315643_ronion
rotations91613843rotations
ruction93611613ruction
rutin55421343_ruti_n
satin55935213_sati_n
section92515663section
sedation9312453sedation
seriation9318063seriation
serration9414053serration
solations9814623solations
solution889593solution
solvation1237773solvation
sorptions1137103sorptions
sortition946703sortition
statin63921463stati_n
stations82415213stations
striation9313483striation
suasion739363suasion
suction93713043suction
sudation9310803sudation
taction93213023taction
talion6317713_talion
tarnation9310093tarnation
taxation1537993taxation
titration9310543titration
toleration1048963toleration
torsion7310803tor_sion
tractions11511613tractions
tradition1047583tradition
train56529113tra_i_n
traitor7310123traitor
triton63914893trit_on
tuition738823tuition
unction9310663unction
uratic83016353urati_c
urination9312173urination
vacation131911893vacation
variation12312393variation
venation11513503venation
vernation12311083vernation
vexation1838783vexation
vibration14138203vibration
violation1238443violation
vocations141911423vocations
volition1179173volition
volution1198603volution
wanion93213063_wanion
zeatin15412823zeati_n
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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273617.26618445.8
3Display Results3613610.1402578.6
 (SQL Overall)1786913617.56223630.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.