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

233 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
donations10111235(None) 
conations111318901conations
donation91513781donation_
dotations101411631dotations
zonations18139311zonations
adnations1039752adnations
adorations11310232adorations
agnations10310032agnations
cognations1339592cognations
conation101420882conation_
connations12312942connations
damnations1337082damnations
darnations1138412darnations
delations102616592delations
dentations11413632dentations
detonations1239372detonations
dilations102614452dilations
dominations14611042dominations
donating10311802donati_ng
donatives13146902donatives
donators9310402donat_ors
dotation91412732dotation_
durations10311462durations
dynatrons1343392dynatrons
enations83316902_enations
iodations1039112iodations
lobations11219612lobations
locations112512742locations
lunations9310722lunations
monitions11310882monitions
nations74720562__nations
nonactions1248372nonactions
notations91512972notations
novations12139002novations
orations81515802_orations
ovations11149262_ovations
ozonations1945142ozonations
phonations1538312phonations
potations111615072potations
pronations12314032pronations
rogations101510822rogations
rotations91613842rotations
solations9814622solations
venations12311722venations
vocations141911422vocations
zonation171410722zonation_
ablations11311513ablations
admonitions1444243admonitions
adnation9310783adnation_
adoptions1245783ado_ptions
adoration10311313adoration_
adulations11310123adulations
advocations1755413advocations
aerations9317903aerations
agnation9311723agnation_
alations82518893_alations
aviations12311553aviations
avocations15168683avocations
carnations12311353carnations
cations94524143__cations
citations11312503citations
coactions1349743coactions
cognation12310753cognation_
cognitions1346043cognitions
coitions10312853co_itions
collations12312853collations
conditions13410103conditions
condonations1548003condonations
conflations16411143conflations
connation11314263connation_
contagions1346603contagions
contains10316533contai_ns
cooptions13107763cooptions
copatrons1346333copatrons
coronations13410703coronations
creations112614543creations
crenations12511693crenations
damnation1238403damnation_
darnation1039823darnation_
dealations11311373dealations
decorations14312883decorations
deflations1439713deflations
delation92318083delation_
deletions102610933deletions
demotions1258443demotions
denegations1348543denegations
denotations1239853denotations
dentation10315243dentation_
dentins83419223den_ti_ns
dentitions1148853dentitions
denudations1346343denudations
derogations1349393derogations
desolations12310593desolations
detonation11310943detonation_
deviations14311163deviations
devotions1356593devotions
diatrons939613d_iatrons
dictations1389703dictations
dictions111812673d_ictions
dilation92215463dilation_
dilutions10248583dilutions
divinations15128413divinations
doating93816863do_ati_ng
domains10510873doma_i_ns
domination13712373domination_
dominions12126553dominions
donates83217223donat__es
donative12139873donati_ve
donator8310263donat_o_r
donjons1536733don__jons
duration9312693duration_
dynatron1243623dynatron_
educations1339233educations
elations83719123_elations
elongations1244663elongations
emanations1289593emanations
enation73419233_enation_
equations1839493equations
evocations15259873evocations
fetations12511383fetations
fixations1936353fixations
flotations1366873flotations
foliations1399943foliations
formations1538203formations
foundations1543433foundations
functions1437743functions
gelations102513093gelations
gnathions1343303_gnathions
gyrations1336923gyrations
halations12312393halations
himations1438803himations
ideations1039903ideations
ignitions1045803ignitions
illations9311393illations
inactions1139323_inactions
intonations1149523intonations
iodation9310383iodation_
iodinations1268843iodinations
ionizations2049893ionizations
isolations10310693isolations
junctions1835943junctions
kations114013663__kations
lavations1238973lavations
laxations1637623laxations
legations102711923legations
lenitions939473lenitions
libations112510443libations
ligations102111993ligations
lineations1039543lineations
lobation102110553lobation_
location102113913location_
locutions11207063locutions
lotions74614763lo__tions
lunation8311923lunation_
luxations1637273luxations
mentations12312583mentations
mentions10312893men_tions
monaxons1744813mona_xons
monition10311723monition_
motions94215003mo__tions
munitions1138173munitions
mutations111211453mutations
nasions73112383__nasions
natations91412493natations
nation64322803__nation_
natrons73215663__natrons
negations102811963negations
nidations1039213nidations
nominations13410533nominations
nonaction1149443nonaction_
nonagons947223nona_gons
nonunions945583nonunions
notation81414603notation_
notions74014483__notions
novation111710013novation_
nunnations1095903nunnations
nutations91411763nutations
oblations1139373oblations
onions64016433_on__ions
options93810603_o_ptions
oration71617713_oration_
ordinations1247993ordinations
ovation101510023_ovation_
ozonation1845673ozonation_
phonathons1843453phonathons
phonation1439393phonation_
pinnations1236883pinnations
planations1238723planations
pontons93315553pon_t_ons
pontoons10279313pon_toons
portions10514413po_rtions
positions11811503positions
potation101716783potation_
potions93417423po__tions
probations14311083probations
pronation11415703pronation_
prorations12314463prorations
punitions1137923punitions
pupations1338123pupations
quotations19146283quotations
rations74123433__rations
relations92418333relations
rogation91612053rogation_
ronions73313343ron__ions
rotation81615453rotation_
ruinations1039603ruinations
sanctions1138873sanctions
sedations10311253sedations
sensations1059853sensations
sinuations1039413sinuations
solation8916153solation_
solutions988883solutions
solvations1336833solvations
sonatina849073sonati_na
sonatinas945683sonatinas
sonatine8313323sonati_ne
sonications1349953sonications
sorptions1137123sorptions
stations82415223_stations
sudations1039903sudations
tarnations1038903tarnations
taxations1636863taxations
unctions1039733_unctions
urinations10310693urinations
vacations141910553vacations
venation11513503venation_
vernations13310333vernations
vexations1937753vexations
violations1337963violations
vocation132311983vocation_
volitions1288663volitions
volutions12108393volutions
wontons103310533won_t_ons

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.453394461.4
2DLD Change Limit1486412337.30020361.8
3Display Results2332330.1062198.1
 (SQL Overall)1786912337.85922737.1
 
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.