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 “agnation” 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
agnation931172(None) 
adnation9310781adnation
agnations10310031agnations
ablation10312432ablation
adnations1039752adnations
aeration8319932aeration
agitation10311222agitation
agnatic10310972agnati_c
alation72920552a_lation
aviation11312742aviation
carnation11312942carnation
cognation12310752cognation
conation101420882conation
damnation1238402damnation
darnation1039822darnation
donation91513782donation
enation73419232_enation
gnathion1243442_gnathion
ignition946532ignition
lunation8311922lunation
nation64322802__nation
pagination1348992pagination
stagnation1145542stagnation
tarnation9310092tarnation
venation11513502venation
zonation171410722zonation
ablations11311513ablations
ablution1047223ablution
abnegation1345413abnegation
abortion1048103abortion
abrasion1046623abrasion
action84719683a__ction
actuation11310333actuation
acylation1448653acylation
adaption1145643adaption
addition1096893addition
adoption1146083adoption
adoration10311313adoration
adulation10311013adulation
aerations9317903aerations
again65218123ag_a_i_n
agatize1739833ag_atize
agatoid948623ag_atoid
agitations11310063agitations
agnail739533agna_i_l
agnails837003agna_ils
agnate73314883agnat__e
agnates82813193agnat_es
agnatical1246163agnatical
agrarian948253agrarian
alations82518893a_lations
alienation1048793alienation
ambition1246563ambition
amnion84812053amn__ion
amotion9710473a_motion
anatto6139913a_natto_
anattos7138453a_nattos
angulation1149553angulation
animation11313683animation
anion55028813a_n__ion
annatto7144153annatto_
annattos8133723annattos
annexation1744953annexation
annotation1047753annotation
annulation1068953annulation
antlion7310293a_ntlion
arcuation11410583arcuation
arnatto7145073arnatto_
arnattos8144363arnattos
assignation1244373assignation
auction93412933a_uction
audition979173audition
aviations12311553aviations
avocation14168993avocation
carnations12311353carnations
caseation1199513caseation
cassation1197913cassation
catenation1249523catenation
cation83925503__cation
caudation1269993caudation
causation1199523causation
citation10314363citation
cognations1339593cognations
cognition1247013cognition
conations111318903conations
connation11314263connation
creation102816513creation
crenation11412923crenation
damnations1337083damnations
darnations1138413darnations
delation92318083delation
dentation10315243dentation
dilation92215463dilation
donations101112353donations
dotation91412733dotation
duration9312693duration
dynatron1243623dynatron
egestion946863egestion
elation73620453_elation
emanation11910783emanation
enations83316903_enations
equation17310483equation
evagination1546563evagination
fetation11613143fetation
fixation1837073fixation
function1337843function
gabion93211033_g_abion
ganglion1044393ganglion
gelation93014433gelation
gnathions1343303_gnathions
gratin74520583_grati_n
gyration1237763gyration
halation11313853halation
himation1339753himation
ideation9310493ideation
ignatia846133ignati_a
ignatias944913ignatias
ignitions1045803ignitions
ignitron943203ignitron
illation8311943illation
imagination1447193imagination
inaction1039623_inaction
iodation9310383iodation
jactation1838143jactation
junction1736203junction
kation104315683__kation
lactation11310813lactation
lallation939493lallation
lamination12311223lamination
laudation1088133laudation
lavation1139973lavation
laxation1538423laxation
legation92412933legation
lenition8310083lenition
libation102411363libation
ligation92313093ligation
lineation9310763lineation
lobation102110553lobation
location102113913location
lunations9310723lunations
luxation1538233luxation
magneton1144943magnet_on
magnetron1243273magnetron
margination1447433margination
marination12312813marination
mentation11313983mentation
mention9314373men_tion
migration12179703migration
monition10311723monition
munition1038763munition
mutation101412883mutation
narration9310063narration
nasion63914083__nasion
natation81513933natation
nations74720563__nations
natron64116023__natron
negation92913023negation
nidation9410583nidation
nonaction1149443nonaction
notation81414603notation
notion64516583__notion
novation111710013novation
nunnation9126563nunnation
nutation81513103nutation
oblation1039863oblation
oration71617713_oration
ovation101510023_ovation
ozonation1845673ozonation
paginations1447763paginations
palmation13310223palmation
palpation1339073palpation
patination12312573patination
phonation1439393phonation
pinnation1138013pinnation
planation11310123planation
potation101716783potation
pronation11415703pronation
punition1038373punition
pupation1269503pupation
radiation10313403radiation
ration64226013__ration
relation82619773relation
rogation91612053rogation
rotation81615453rotation
ruination9311273ruination
saltation9312003saltation
salvation1239293salvation
sanction1049533sanction
satiation9313433satiation
sedation9312453sedation
sensation9510583sensation
sinuation9310413sinuation
solation8916153solation
stagnations1244903stagnations
station72717243_station
sudation9310803sudation
tarnations1038903tarnations
taxation1537993taxation
unction9310663_unction
urination9312173urination
vacation131911893vacation
vallation1239753vallation
valuation1249973valuation
variation12312393variation
venations12311723venations
vernation12311083vernation
vexation1838783vexation
vocation132311983vocation
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 Filter1786911461620.580308087.9
2DLD Change Limit1461622098.18617855.1
3Display Results2092090.0932247.3
 (SQL Overall)1786912098.85920170.6
 
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.