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

222 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
durations1031146(None) 
duration9312691duration_
adjurations1944822adjurations
adorations11310242adorations
adulations11310122adulations
aerations9317902aerations
darnations1138412darnations
delations102616592delations
dilations102614452dilations
donations101112352donations
dotations101411632dotations
duratives1346222duratives
durions839962dur__ions
educations1339232educations
furcations1547532furcations
gyrations1336922gyrations
indurations1249582indurations
lunations9310722lunations
luxations1637272luxations
mutations111211452mutations
nutations91411762nutations
orations81515802_orations
pupations1338122pupations
purgations1346742purgations
rations74123432__rations
sudations1039902sudations
abjurations2045143abjurations
ablations11311513ablations
abrasions1145823abrasions
adjuration1845523adjuration_
admirations1446693admirations
adnations1039753adnations
adoration10311313adoration_
adulation10311013adulation_
adumbrations1752293adumbrations
aeration8319933aeration_
agnations10310033agnations
alations82518893_alations
auctions104012143au_ctions
auditions1078753auditions
aviations12311563aviations
burtons9310853bur_t_ons
carnations12311353carnations
cations94524143__cations
caudations13108223caudations
causations1268143causations
ceratins102818733cerati_ns
citations11312503citations
conations111318903conations
cratons94316033_crat_ons
creations112614543creations
curating11314293curati_ng
curatives1437823curatives
curators10311723curat_ors
curtains10259703curtai_ns
damnations1337083damnations
darnation1039823darnation_
deaerations12311673deaerations
dealations11311373dealations
decorations14312883decorations
deflations1439713deflations
delation92318083delation_
deletions102610933deletions
demotions1258443demotions
dentations11413633dentations
denudations1346343denudations
deputations1448343deputations
deraigns1034883dera_igns
derating103222283derati_ng
derisions1038843derisions
derivations15611493derivations
derogations1349393derogations
detractions14118273detractions
detritions1148953detritions
deuterations1348083deuterations
deviations14311173deviations
devotions1356593devotions
diatrons939623d_iatrons
dictations1389703dictations
dictions111812673d_ictions
dilation92215463dilation_
dilutions10248583dilutions
directions1379643directions
donation91513783donation_
dotation91412733dotation_
dragons938383d_ra_gons
dragoons1045013d_ragoons
drains73719403d_ra_i_ns
dubitations1456673dubitations
duramens1195153dura_mens
durative1239073durati_ve
durians839573dur__ians
durion7510963dur__ion_
dynatrons1343393dynatrons
education12310203education_
eductions1268773edu_ctions
elations83719123_elations
emulations12310943emulations
enations83316903_enations
equations1839493equations
erasions8310983_erasions
eruptions1146763eruptions
exudations18107073exudations
federations1548883federations
fetations12511383fetations
figurations1545083figurations
fixations1936353fixations
formations1538203formations
fractions1449103_fractions
fruitions12106113fruitions
functions1437743functions
furcation1448353furcation_
gelations102513093gelations
gratins84119183_grati_ns
gumptions1443773gumptions
gustations1147233gustations
guttations1145593guttations
gyration1237763gyration_
halations12312393halations
himations1438803himations
hydrations1745283hydrations
ideations1039903ideations
illations9311393illations
induration11410613induration_
iodations1039113iodations
iterations10413823iterations
junctions1835943junctions
kations114013663__kations
keratins122313483kerati_ns
laudations1146843laudations
laureations1145573laureations
lavations1238973lavations
laxations1637623laxations
legations102711923legations
libations112510443libations
librations12149063librations
ligations102111993ligations
lobations11219613lobations
locations112512743locations
lunation8311923lunation_
lustrations1147623lustrations
luxation1538233luxation_
marathons1446423marathons
maturations1348443maturations
migrations13168683migrations
moderations1448273moderations
modulations14147263modulations
munitions1138173munitions
mutation101412883mutation_
narrations1038943narrations
natations91412493natations
nations74720563__nations
negations102811963negations
nervations1359483nervations
nidations1039213nidations
nitrations10312033nitrations
nodulations12147003nodulations
notations91512973notations
novations12139003novations
numerations13127293numerations
nunnations1095903nunnations
nutation81513103nutation_
nutritions1066513nutritions
oblations1139373oblations
obturations13116423obturations
operations12312953operations
oration71617713_oration_
ovations11149263_ovations
ovulations1337973ovulations
parathions1545333parathions
portions10514413por_tions
potations111615073potations
prorations12314463prorations
pulsations1236373pulsations
punitions1137923punitions
pupation1269503pupation_
purgation1247393purgation_
questions1845523questions
quotations19146283quotations
ration64226013__ration_
ratios64922673__ratio_s
ratoons73815473__ratoons
rattons73815323__rattons
relations92418333relations
rogations101510823rogations
rotations91613843rotations
ructions102811683ru_ctions
ruinations1039603ruinations
saturations1148573saturations
sedations10311253sedations
seriations10316683seriations
serrations10313103serrations
solations9814623solations
sorptions1137123sorptions
stations82415223_stations
striations10312793striations
suasions838783su_asions
sublations12410113sublations
suctions103012903su_ctions
sudation9310803sudation_
sulcations1289583sulcations
sulfations13107813sulfations
summations1456783summations
tarnations1038903tarnations
taxations1636863taxations
titrations1039173titrations
tractions11511623_tractions
tuitions838283tu_itions
turions7311573tur__ions
ululations1037143ululations
unctions1039733_unctions
undulations1246053undulations
urinations10310693_urinations
usurpations1343473usurpations
vacations141910553vacations
variations13310773variations
venations12311723venations
vernations13310333vernations
vexations1937753vexations
vibrations15157373vibrations
vocations141911423vocations
zonations18139313zonations

Search took 9 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.423422437.4
2DLD Change Limit1486412227.87318879.8
3Display Results2222220.1261761.9
 (SQL Overall)1786912228.42221217.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.