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

232 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
ovations1114926(None) 
novations12139001novations
orations81515801orations
ovation101510021ovation_
alations82518892alations
aviations12311552aviations
cations94524142_cations
conations111318902conations
donations101112352donations
dotations101411632dotations
elations83719122elations
enations83316902enations
evasions1136542evasions
iodations1039112iodations
kations114013662_kations
lavations1238972lavations
lobations11219612lobations
locations112512742locations
nations74720562_nations
notations91512972notations
novation111710012novation_
oblations1139372oblations
obviations1545462obviations
options93810602o_ptions
oration71617712oration_
ovational1246852ovational
ovulations1337972ovulations
potations111615072potations
rations74123432_rations
rogations101510822rogations
rotations91613842rotations
solations9814622solations
solvations1336832solvations
stations82415222stations
vocations141911422vocations
zonations18139312zonations
ablations11311513ablations
actions94218513_actions
adaptions1245223adaptions
adnations1039753adnations
adorations11310233adorations
aerations9317903aerations
agnations10310033agnations
alation72920553alation_
amotions1069843amotions
anions64123033__anions
auctions104012143auctions
aviation11312743aviation_
avions94114393__avions
avocations15168683avocations
axions134713483__axions
basions94213953_basions
bastions10411693bastions
batons85519423_bat_ons
bevatrons1443713bevatrons
bloviations1643753bloviations
camions113916133_camions
captions123813223captions
cation83925503_cation_
cautions103313183cautions
citations11312503citations
clarions10310493clarions
clavations1546183clavations
coactions1349743coactions
cognations1339593cognations
coitions10312853coitions
collations12312853collations
conation101420883conation_
connations12312943connations
cooptions13107763cooptions
copatrons1346333copatrons
cratons94316033crat_ons
creations112614543creations
delations102616593delations
deviations14311163deviations
devotions1356593devotions
diatrons939613diatrons
dictions111812673dictions
dilations102614453dilations
donation91513783donation_
dotation91412733dotation_
durations10311463durations
editions9310403editions
elation73620453elation_
elevations1338633elevations
elutions82513053elutions
emotions10610283emotions
enation73419233enation_
equations1839493equations
erasions8310983erasions
evasion1036753evasion_
evections142510693evections
evictions14228623evictions
evocations15259873evocations
exactions1838923exactions
factions133013063factions
fanions103713073_fanions
fetations12511383fetations
fictions132410743fictions
fixations1936353fixations
flatirons1244483flatirons
flotations1366873flotations
foliations1399943foliations
formations1538203formations
fractions1449103fractions
gabions102410053_gabions
gelations102513093gelations
gnathions1343303gnathions
gratins84119183grati_ns
gyrations1336923gyrations
halations12312393halations
himations1438803himations
ideations1039903ideations
illations9311393illations
inactions1139323inactions
innovations1445263innovations
invasions12115413invasions
iodation9310383iodation_
isatins7310773isati_ns
isolations10310693isolations
kation104315683_kation_
latinos73613803_latinos
lavation1139973lavation_
laxations1637623laxations
lections102413843lections
legations102711923legations
libations112510443libations
ligations102111993ligations
lobation102110553lobation_
location102113913location_
locutions11207063locutions
lotions74614763_lotions
lunations9310723lunations
luxations1637273luxations
matins84527783_mati_ns
matrons93517633_matrons
mentions10312893mentions
monitions11310883monitions
motions94215003_motions
motivations1647093motivations
mutations111211453mutations
nasions73112383_nasions
natations91412493natations
nation64322803_nation_
natrons73215663_natrons
negations102811963negations
nervations1359483nervations
nidations1039213nidations
nonactions1248373nonactions
notation81414603notation_
notions74014483_notions
nutations91411763nutations
oblation1039863oblation_
obtains939163obtai_ns
obviation1446093obviation_
occasions1344063occasions
octagons1144493octagons
olfactions1563873olfactions
onions64016433o__nions
operations12312953operations
opinions1045933opinions
option83612713o_ption_
orating83520323orati_ng
orators7313823orat_ors
ovarian1037643ovarian_
ovaries10312653ovari_es
ovariole1144923ovariole
ovarioles1244613ovarioles
ovaritis1145953ovaritis
overactions1648213overactions
ovulation1238983ovulation_
oxidations1845443oxidations
ozonations1945143ozonations
pactions122613503pactions
patins87528783_pati_ns
patios85221783_patio_s
patrons93818103_patrons
phonations1538313phonations
platoons1038683platoons
portions10514413portions
positions11811503positions
potation101716783potation_
potions93417423_potions
privations15310103privations
probations14311083probations
pronations12314033pronations
prorations12314463prorations
pupations1338123pupations
quotations19146283quotations
ration64226013_ration_
ratios64922673_ratio_s
ratoons73815473_ratoons
rattons73815323_rattons
reactions11711713reactions
relations92418333relations
renovations1448423renovations
rogation91612053rogation_
rotation81615453rotation_
ructions102811683ructions
salvations1338133salvations
satins64930483_sati_ns
sections102714703sections
sedations10311253sedations
solation8916153solation_
solutions988883solutions
solvation1237773solvation_
sorptions1137123sorptions
statins73719773stati_ns
station72717243station_
suasions838783suasions
suctions103012903suctions
sudations1039903sudations
tactions102912423tactions
talions7314113_talions
taxations1636863taxations
tevatrons1244003tevatrons
tractions11511623tractions
tuitions838283tuitions
unctions1039733unctions
vacations141910553vacations
various103113103_various
venations12311723venations
vexations1937753vexations
violations1337963violations
virions1039873_virions
visions10311023_visions
vocation132311983vocation_
volitions1288663volitions
volutions12108393volutions
wanions104011373_wanions
zeatins16311733zeati_ns
zonation171410723zonation_

Search took 10 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.563317390.8
2DLD Change Limit1461622328.95316325.5
3Display Results2322320.1102109.1
 (SQL Overall)1786912329.62618563.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.