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

207 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
adnations103975(None) 
adnation9310781adnation_
agnations10310031agnations
ablations11311512ablations
adaptions1245222adaptions
additions1186332additions
adoptions1245782adoptions
adorations11310232adorations
adulations11310122adulations
aerations9317902aerations
agnation9311722agnation_
alations82518892a_lations
aviations12311552aviations
carnations12311352carnations
conations111318902conations
damnations1337082damnations
darnations1138412darnations
donations101112352donations
enations83316902_enations
ideations1039902ideations
lunations9310722lunations
nations74720562__nations
radiations11311922radiations
tarnations1038902tarnations
venations12311722venations
zonations18139312zonations
abdications1657653abdications
abductions15125383abductions
ablation10312433ablation_
ablutions1146603ablutions
abnegations1444923abnegations
abortions1147783abortions
abrasions1145813abrasions
actions94218513a__ctions
actuations1239293actuations
acylations1547603acylations
adagios945513ad_agio_s
adaptations1464573adaptations
adaption1145643adaption_
addictions14125363addictions
addition1096893addition_
adductions14104953adductions
ademptions1543383ademptions
adhesions1343793adhesions
adjunctions2143143adjunctions
adjurations1944823adjurations
admirations1446693admirations
admonitions1444243admonitions
adoption1146083adoption_
adoration10311313adoration_
adulation10311013adulation_
advections1645553advections
advocations1755413advocations
aeration8319933aeration_
agitations11310063agitations
alation72920553a_lation_
alienations1147883alienations
ambitions1346343ambitions
amnions93710913amn__ions
amotions1069843a_motions
anattos7138453a_natto_s
andantinos1152243andantinos
animations12312193animations
anions64123033a_n__ions
annattos8133723annatto_s
annexations1844263annexations
annotations1146883annotations
annulations1167833annulations
antlions839193a_ntlions
arcuations1249343arcuations
arnattos8144363arnatto_s
auctions104012143a_uctions
auditions1078753auditions
aviation11312743aviation_
avocations15168683avocations
carnation11312943carnation_
caseations1258303caseations
cassations1276873cassations
catenations1348363catenations
cations94524143__cations
caudations13108223caudations
causations1268143causations
citations11312503citations
cognations1339593cognations
conation101420883conation_
connations12312943connations
creations112614543creations
crenations12511693crenations
damnation1238403damnation_
darnation1039823darnation_
delations102616593delations
dentations11413633dentations
diatrons939613_diatrons
dictions111812673_dictions
dilations102614453dilations
donation91513783donation_
dotations101411633dotations
durations10311463durations
dynatrons1343393dynatrons
editions9310403ed_itions
educations1339233educations
eductions1268773eductions
elations83719123_elations
emanations1289593emanations
enation73419233_enation_
equations1839493equations
fetations12511383fetations
fixations1936353fixations
functions1437743functions
gelations102513093gelations
gnathions1343303_gnathions
gradations1286863grad_ations
graduations1385233graduations
gyrations1336923gyrations
halations12312393halations
himations1438803himations
hydrations1745283hydrations
ideation9310493ideation_
ignitions1045803ignitions
illations9311393illations
inactions1139323_inactions
iodations1039113iodations
iodinations1268843iodinations
jactations1936893jactations
junctions1835943junctions
kations114013663__kations
lactations1239423lactations
lallations1038743lallations
laminations1339803laminations
laudations1146843laudations
lavations1238973lavations
laxations1637623laxations
legations102711923legations
lenitions939473lenitions
libations112510443libations
ligations102111993ligations
lineations1039543lineations
lobations11219613lobations
locations112512743locations
lunation8311923lunation_
luxations1637273luxations
marinations13411273marinations
mediations13310983mediations
mentations12312583mentations
mentions10312893men_tions
monitions11310883monitions
munitions1138173munitions
mutations111211453mutations
narrations1038943narrations
nasions73112383__nasions
natations91412493natations
nation64322803__nation_
natrons73215663__natrons
negations102811963negations
nidations1039213nidations
nonactions1248373nonactions
notations91512973notations
notions74014483__notions
novations12139003novations
nunnations1095903nunnations
nutations91411763nutations
oblations1139373oblations
orations81515803_orations
ordinations1247993ordinations
ovations11149263_ovations
ozonations1945143ozonations
paginations1447753paginations
palmations1438733palmations
palpations1437653palpations
patinations13411003patinations
phonations1538313phonations
pinnations1236883pinnations
planations1238723planations
potations111615073potations
pronations12314033pronations
punitions1137923punitions
pupations1338123pupations
radiation10313393radiation_
rations74123433__rations
relations92418333relations
rogations101510823rogations
rotations91613843rotations
ruinations1039603ruinations
saltations10310623saltations
salvations1338133salvations
sanctions1138873sanctions
satiations10312113satiations
sedations10311253sedations
sensations1059853sensations
sinuations1039413sinuations
solations9814623solations
stagnations1244903stagnations
stations82415223_stations
sudations1039903sudations
tarnation9310093tarnation_
taxations1636863taxations
unctions1039733_unctions
urinations10310693urinations
vacations141910553vacations
vallations1339083vallations
valuations1348783valuations
variations13310773variations
venation11513503venation_
vernations13310333vernations
vexations1937753vexations
vocations141911423vocations
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 Limit1486412077.20620627.4
3Display Results2072070.0932225.8
 (SQL Overall)1786912077.71923149.5
 
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.