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

209 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
notations9151297(None) 
dotations101411631dotations
natations91412491natations
notation81414601notation_
novations12139001novations
nutations91411761nutations
potations111615071potations
rotations91613841rotations
annotations1146882annotations
citations11312502citations
conations111318902conations
denotations1239852denotations
donations101112352donations
dotation91412732dotation_
fetations12511382fetations
flotations1366872flotations
iodations1039112iodations
lobations11219612lobations
locations112512742locations
mutations111211452mutations
natation81513932natation_
nations74720562n__ations
negations102811962negations
nictations1278312nictations
nidations1039212nidations
nitrations10312032nitrations
nonactions1248372nonactions
notating92513342notati_ng
notational1048122notational
notions74014482no__tions
novation111710012novation_
nutation81513102nutation_
orations81515802_orations
ovations11149262_ovations
potation101716782potation_
quotations19146282quotations
rogations101510822rogations
rotation81615452rotation_
solations9814622solations
stations82415222_stations
vocations141911422vocations
zonations18139312zonations
ablations11311503ablations
actuations1239293actuations
adnations1039753adnations
adorations11310233adorations
aerations9317903aerations
agitations11310063agitations
agnations10310033agnations
alations82518893_alations
animations12312193animations
annotation1047753annotation_
aviations12311553aviations
avocations15168683avocations
betatrons1145083betatrons
cations94524143__cations
citation10314363citation_
coactions1349743coactions
coaptations1547543coaptations
cogitations1448903cogitations
cognations1339593cognations
coitions10312853co_itions
collations12312853collations
conation101420883conation_
connations12312943connations
connotations1447283connotations
contagions1346603contagions
cooptions13107763cooptions
copatrons1346333copatrons
corotations1349763corotations
cottons9312193cot_t_ons
creations112614543creations
cunctations1576153cunctations
delations102616593delations
denotation11311083denotation_
dentations11413633dentations
dictations1389703dictations
dilations102614453dilations
donation91513783donation_
durations10311463durations
elations83719123_elations
enations83316903_enations
equations1839493equations
evocations15259873evocations
fetation11613143fetation_
fixations1936353fixations
floatations1444103floatations
flotation1267813flotation_
foliations1399943foliations
formations1538203formations
gelations102513093gelations
gestations1139773gestations
gustations1147233gustations
guttations1145593guttations
gyrations1336923gyrations
halations12312393halations
himations1438803himations
ideations1039903ideations
illations9311393illations
imitations1259963imitations
incitations13310883incitations
inflations13310323inflations
initiations11410723initiations
innovations1445263innovations
insolations1149183insolations
intonations1149523intonations
invitations1449053invitations
invocations1647063invocations
iodation9310383iodation_
isolations10310693isolations
jactations1936893jactations
kations114013663__kations
lactations1239423lactations
lavations1238973lavations
laxations1637623laxations
legations102711923legations
libations112510443libations
ligations102111993ligations
lobation102110553lobation_
location102113913location_
locutions11207063locutions
lotions74614763lo__tions
lunations9310723lunations
luxations1637273luxations
mentations12312583mentations
monitions11310883monitions
motions94215003mo__tions
motivations1647093motivations
mutation101412883mutation_
narrations1038943narrations
nasions73112383n__asions
nation64322803n__ation_
natrons73215663n__atrons
negation92913023negation_
negatons9299273negat_ons
negatrons10275843negatrons
negotiations1345153negotiations
nervations1359483nervations
nictation1189273nictation_
nidation9410583nidation_
nitration9313443nitration_
nodulations12147003nodulations
nominations13410533nominations
nonaction1149443nonaction_
nonagons947223nona_gons
nonunions945583nonunions
notaries8314933notari_es
notarizes1848713notarizes
notates72817483notat__es
notion64516583no__tion_
notorious946213notorious
nunnations1095903nunnations
nutating92411953nutati_ng
nutational1047043nutational
nutritions1066513nutritions
nystatins1244753nystati_ns
oblations1139363oblations
options93810603_o_ptions
oration71617713_oration_
ovation101510023_ovation_
ozonations1945143ozonations
peltations12311553peltations
petitions11511083petitions
phonations1538313phonations
portions10514413po_rtions
positions11811503positions
potatoes1039943potat_oes
potions93417423po__tions
probations14311073probations
pronations12314033pronations
prorations12314463prorations
punctations1585353punctations
pupations1338123pupations
quotation18146973quotation_
rations74123433__rations
relations92418333relations
renovations1448423renovations
restations10315843restations
rogation91612053rogation_
rotating92614553rotati_ng
rotational1048093rotational
rotators8310203rotat_ors
saltations10310623saltations
sanitations11410843sanitations
satiations10312113satiations
sedations10311253sedations
siltations1038553siltations
situations1038433situations
solation8916153solation_
solutions988883solutions
solvations1336833solvations
sorptions1137123sorptions
sortitions1046423sortitions
statins73719773_stati_ns
station72717243_station_
sudations1039903sudations
tactions102912423__tactions
talions7314103__talions
taxations1636863taxations
titrations1039173titrations
vacations141910553vacations
venations12311723venations
vexations1937753vexations
violations1337963violations
vitiations1338743vitiations
vocation132311983vocation_
volitions1288663volitions
volutions12108393volutions
zonation171410723zonation_

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.1731032896.0
2DLD Change Limit1486412097.81319024.8
3Display Results2092090.0932247.3
 (SQL Overall)1786912098.07922118.0
 
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.