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

213 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
dotations10141163(None) 
donations101112351donations
dotation91412731dotation_
notations91512971notations
potations111615071potations
rotations91613841rotations
adorations11310232adorations
citations11312502citations
conations111318902conations
delations102616592delations
denotations1239852denotations
dentations11413632dentations
dictations1389702dictations
dilations102614452dilations
donation91513782donation_
durations10311462durations
fetations12511382fetations
flotations1366872flotations
iodations1039112iodations
lobations11219612lobations
locations112512742locations
mutations111211452mutations
natations91412492natations
notation81414602notation_
novations12139002novations
nutations91411762nutations
orations81515802_orations
ovations11149262_ovations
potation101716782potation_
quotations19146282quotations
rogations101510822rogations
rotation81615452rotation_
solations9814622solations
stations82415222_stations
vocations141911422vocations
zonations18139312zonations
ablations11311513ablations
actuations1239293actuations
adaptations1464573adaptations
adnations1039753adnations
adoptions1245783ado_ptions
adoration10311313adoration_
adulations11310123adulations
advocations1755413advocations
aerations9317903aerations
agitations11310063agitations
agnations10310033agnations
alations82518893_alations
annotations1146883annotations
aviations12311553aviations
avocations15168683avocations
betatrons1145083betatrons
cations94524143__cations
citation10314363citation_
coactions1349743coactions
coaptations1547543coaptations
cogitations1448903cogitations
cognations1339593cognations
coitions10312853co_itions
collations12312853collations
conation101420883conation_
connations12312943connations
contagions1346603contagions
cooptions13107763cooptions
copatrons1346333copatrons
corotations1349763corotations
cottons9312193cot_t_ons
creations112614543creations
damnations1337083damnations
darnations1138413darnations
dealations11311373dealations
decorations14312883decorations
deflations1439713deflations
delation92318083delation_
deletions102610933deletions
demotions1258443demotions
denotation11311083denotation_
dentation10315243dentation_
dentitions1148853dentitions
deportations1548463deportations
deputations1448343deputations
derogations1349393derogations
desolations12310593desolations
detains83716093deta_i_ns
detections131410043detections
detentions11148803detentions
detonations1239373detonations
detractions14118273detractions
detritions1148953detritions
deviations14311163deviations
devotions1356593devotions
diatrons939613d_iatrons
dictation12810563dictation_
dictions111812673d_ictions
dilatations1246413dilatations
dilation92215463dilation_
dilutions10248583dilutions
doating93816863do_ati_ng
domains10510873doma_i_ns
dominations14611043dominations
dominions12126553dominions
donating10311803donati_ng
donatives13146903donatives
donators9310403donat_ors
dotting93314483dot_ti_ng
dubitations1456673dubitations
duration9312693duration_
dynatrons1343393dynatrons
educations1339233educations
elations83719123_elations
enations83316903_enations
equations1839493equations
evocations15259873evocations
fetation11613143fetation_
fixations1936353fixations
floatations1444103floatations
flotation1267813flotation_
foliations1399943foliations
formations1538203formations
gelations102513093gelations
gestations1139773gestations
gustations1147233gustations
guttations1145593guttations
gyrations1336923gyrations
halations12312393halations
himations1438803himations
ideations1039903ideations
illations9311393illations
imitations1259963imitations
iodation9310383iodation_
isolations10310693isolations
jactations1936893jactations
kations114013663__kations
lactations1239423lactations
lavations1238973lavations
laxations1637623laxations
legations102711923legations
libations112510443libations
ligations102111993ligations
lobation102110553lobation_
location102113913location_
locutions11207063locutions
lotions74614763lo__tions
lunations9310723lunations
luxations1637273luxations
meditations1449333meditations
mentations12312583mentations
monitions11310883monitions
motions94215003mo__tions
motivations1647093motivations
mutation101412883mutation_
natation81513933natation_
nations74720563__nations
negations102811963negations
nictations1278313nictations
nidations1039213nidations
nitrations10312033nitrations
nonactions1248373nonactions
notating92513343notati_ng
notational1048123notational
notions74014483no__tions
novation111710013novation_
nutation81513103nutation_
oblations1139373oblations
options93810603_o_ptions
oration71617713_oration_
ovation101510023_ovation_
ozonations1945143ozonations
peltations12311553peltations
petitions11511083petitions
phonations1538313phonations
portions10514413po_rtions
positions11811503positions
potatoes1039943potat_oes
potions93417423po__tions
probations14311083probations
pronations12314033pronations
prorations12314463prorations
pupations1338123pupations
quotation18146973quotation_
rations74123433__rations
relations92418333relations
restations10315843restations
rogation91612053rogation_
rotating92614553rotati_ng
rotational1048093rotational
rotators8310203rotat_ors
saltations10310623saltations
satiations10312113satiations
sedations10311253sedations
siltations1038553siltations
situations1038433situations
solation8916153solation_
solutions988883solutions
solvations1336833solvations
sorptions1137123sorptions
sortitions1046423sortitions
statins73719773_stati_ns
station72717243_station_
sudations1039903sudations
tactions102912423__tactions
talions7314113__talions
taxations1636863taxations
titrations1039173titrations
vacations141910553vacations
venations12311723venations
vexations1937753vexations
violations1337963violations
vitiations1338743vitiations
vocation132311983vocation_
volitions1288663volitions
volutions12108393volutions
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 Filter1786911486410.420425454.8
2DLD Change Limit1486412136.81321817.3
3Display Results2132130.1101936.4
 (SQL Overall)1786912137.34324334.9
 
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.