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

216 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
dotation9141273(None) 
donation91513781donation
dotations101411631dotations
notation81414601notation
potation101716781potation
rotation81615451rotation
adoration10311312adoration
citation10314362citation
conation101420882conation
delation92318082delation
denotation11311082denotation
dentation10315242dentation
dictation12810562dictation
dilation92215462dilation
donations101112352donations
duration9312692duration
fetation11613142fetation
flotation1267812flotation
iodation9310382iodation
lobation102110552lobation
location102113912location
mutation101412882mutation
natation81513932natation
notations91512972notations
novation111710012novation
nutation81513102nutation
oration71617712_oration
ovation101510022_ovation
potations111615072potations
quotation18146972quotation
rogation91612052rogation
rotations91613842rotations
solation8916152solation
station72717242_station
vocation132311982vocation
zonation171410722zonation
ablation10312433ablation
actuation11310333actuation
adaptation1355223adaptation
adnation9310783adnation
adoption1146083ado_ption
adorations11310233adorations
adulation10311013adulation
advocation1645743advocation
aeration8319933aeration
agitation10311223agitation
agnation9311723agnation
alation72920553_alation
annotation1047753annotation
aviation11312743aviation
avocation14168993avocation
betatron1045223betatron
cation83925503__cation
citations11312503citations
coaction12310773coaction
coaptation1448343coaptation
cogitation13410083cogitation
cognation12310753cognation
coition9314313co_ition
collation11313993collation
conations111318903conations
connation11314263connation
contagion1246993contagion
cooption1288343cooption
copatron1246753copatron
corotation12410973corotation
cotton8312993cot_t_on
creation102816513creation
damnation1238403damnation
darnation1039823darnation
dealation10313003dealation
decoration13314423decoration
deflation13310653deflation
delations102616593delations
deletion92011973deletion
demotion1169073demotion
denotations1239853denotations
dentations11413633dentations
dentition1049633dentition
deportation1449303deportation
deputation1339393deputation
derogation12410393derogation
desolation11311403desolation
detain74617383deta_i_n
detection121310413detection
detention10169543detention
detonation11310943detonation
detraction13138583detraction
detrition1049133detrition
deviation13312393deviation
devotion1256763devotion
diatron839283d_iatron
dictations1389703dictations
diction102313053d_iction
dilatation1147393dilatation
dilations102614453dilations
dilution9239143dilution
doating93816863do_ating
domain9511323doma_i_n
domination13712373domination
dominion11147033dominion
donating10311803donating
donative12139873donative
donator8310263donat_or
dottier83910923dot_tier
dottily1147283dot_tily
dotting93314483dot_ting
dubitation1377333dubitation
durations10311463durations
dynatron1243623dynatron
education12310203education
elation73620453_elation
enation73419233_enation
equation17310483equation
evocation142010293evocation
fetations12511383fetations
fixation1837073fixation
floatation1344683floatation
flotations1366873flotations
foliation121110793foliation
formation1439423formation
gelation93014433gelation
gestation10310663gestation
gustation1047963gustation
guttation1046173guttation
gyration1237763gyration
halation11313853halation
himation1339753himation
ideation9310493ideation
illation8311943illation
imitation11510853imitation
iodations1039113iodations
isolation9311643isolation
jactation1838143jactation
kation104315683__kation
lactation11310813lactation
lavation1139973lavation
laxation1538423laxation
legation92412933legation
libation102411363libation
ligation92313093ligation
lobations11219613lobations
locations112512743locations
locution10227663locution
lotion65716523lo__tion
lunation8311923lunation
luxation1538233luxation
meditation13410743meditation
mentation11313983mentation
monition10311723monition
motion85217553mo__tion
motivation1548083motivation
mutations111211453mutations
natations91412493natations
nation64322803__nation
negation92913023negation
nictation1189273nictation
nidation9410583nidation
nitration9313443nitration
nonaction1149443nonaction
notating92513343notating
notational1048123notational
notion64516583no__tion
novations12139003novations
nutations91411763nutations
oblation1039863oblation
option83612713_o_ption
orations81515803_orations
ovations11149263_ovations
ozonation1845673ozonation
peltation11312963peltation
petition10711753petition
phonation1439393phonation
portion9615493po_rtion
position10912193position
potato8513433potat_o_
potion84519573po__tion
probation13412183probation
pronation11415703pronation
proration11415983proration
pupation1269503pupation
quotations19146283quotations
ration64226013__ration
relation82619773relation
restation9316913restation
rogations101510823rogations
rotating92614553rotating
rotational1048093rotational
rotative11310343rotative
rotator7310833rotat_or
saltation9312003saltation
satiation9313433satiation
sedation9312453sedation
siltation939213siltation
situation949423situation
solations9814623solations
solution889593solution
solvation1237773solvation
sorption1037513sorption
sortition946703sortition
statin63921473_stati_n
stations82415223_stations
sudation9310803sudation
taction93213023__taction
talion6317713__talion
taxation1537993taxation
titration9310543titration
vacation131911893vacation
venation11513503venation
vexation1838783vexation
violation1238443violation
vitiation1239563vitiation
vocations141911423vocations
volition1179173volition
volution1198603volution
zonations18139313zonations

Search took 7 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.420425454.8
2DLD Change Limit1461622166.34623032.1
3Display Results2162160.0762842.1
 (SQL Overall)1786912166.84226116.8
 
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.