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

201 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
agnations1031003(None) 
adnations1039751adnations
agnation9311721agnation_
ablations11311512ablations
adnation9310782adnation_
aerations9317902aerations
agitations11310062agitations
alations82518892a_lations
aviations12311552aviations
carnations12311352carnations
cognations1339592cognations
conations111318902conations
damnations1337082damnations
darnations1138412darnations
donations101112352donations
enations83316902_enations
gnathions1343302_gnathions
ignitions1045802ignitions
lunations9310722lunations
nations74720562__nations
paginations1447752paginations
stagnations1244902stagnations
tarnations1038902tarnations
venations12311722venations
zonations18139312zonations
ablation10312433ablation_
ablutions1146603ablutions
abnegations1444923abnegations
abortions1147783abortions
abrasions1145813abrasions
actions94218513a__ctions
actuations1239293actuations
acylations1547603acylations
adaptions1245223adaptions
additions1186333additions
adoptions1245783adoptions
adorations11310233adorations
adulations11310123adulations
aeration8319933aeration_
agatizes1838863ag_atizes
agitation10311223agitation_
agnails837003agna_i_ls
agnates82813193agnat__es
agnatic10310973agnati__c
agnatical1246163agnatical
agrarians1045793agrarians
alation72920553a_lation_
alienations1147883alienations
ambitions1346343ambitions
amnions93710913amn__ions
amotions1069843a_motions
anattos7138453a_natto_s
angulations1268053angulations
animations12312193animations
anions64123033a_n__ions
annattos8133723annatto_s
annexations1844263annexations
annotations1146883annotations
annulations1167833annulations
antlions839193a_ntlions
arcuations1249343arcuations
arnattos8144363arnatto_s
assignations1344163assignations
auctions104012143a_uctions
auditions1078753auditions
aviation11312743aviation_
avocations15168683avocations
carnation11312943carnation_
caseations1258303caseations
cassations1276873cassations
catenations1348363catenations
cations94524143__cations
caudations13108223caudations
causations1268143causations
citations11312503citations
cognation12310753cognation_
cognitions1346043cognitions
conation101420883conation_
connations12312943connations
creations112614543creations
crenations12511693crenations
damnation1238403damnation_
darnation1039823darnation_
delations102616593delations
dentations11413633dentations
dilations102614453dilations
donation91513783donation_
dotations101411633dotations
durations10311463durations
dynatrons1343393dynatrons
egestions1046703egestions
elations83719123_elations
emanations1289593emanations
enation73419233_enation_
equations1839493equations
evaginations1645823evaginations
fetations12511383fetations
fixations1936353fixations
functions1437743functions
gabions102410053_g_abions
ganglions1144063ganglions
gelations102513093gelations
gnathion1243443_gnathion_
gratins84119183_grati_ns
gyrations1336923gyrations
halations12312393halations
himations1438803himations
ideations1039903ideations
ignatias944913ignati_as
ignition946533ignition_
ignitrons1042993ignitrons
illations9311393illations
imaginations1546343imaginations
inactions1139323_inactions
iodations1039113iodations
jactations1936893jactations
junctions1835943junctions
kations114013663__kations
lactations1239423lactations
lallations1038743lallations
laminations1339803laminations
laudations1146843laudations
lavations1238973lavations
laxations1637623laxations
legations102711923legations
lenitions939473lenitions
libations112510443libations
ligations102111993ligations
lineations1039543lineations
lobations11219613lobations
locations112512743locations
lunation8311923lunation_
luxations1637273luxations
magnetons1244543magnet_ons
magnetrons1343073magnetrons
marginations1546453marginations
marinations13411273marinations
mentations12312583mentations
mentions10312893men_tions
migrations13168683migrations
monitions11310883monitions
munitions1138173munitions
mutations111211453mutations
narrations1038943narrations
nasions73112383__nasions
natations91412493natations
nation64322803__nation_
natrons73215663__natrons
negations102811963negations
nidations1039213nidations
nonactions1248373nonactions
notations91512973notations
notions74014483__notions
novations12139003novations
nunnations1095903nunnations
nutations91411763nutations
oblations1139373oblations
orations81515803_orations
ovations11149263_ovations
ozonations1945143ozonations
pagination1348993pagination_
palmations1438733palmations
palpations1437653palpations
patinations13411003patinations
phonations1538313phonations
pinnations1236883pinnations
planations1238723planations
potations111615073potations
pronations12314033pronations
punitions1137923punitions
pupations1338123pupations
radiations11311923radiations
rations74123433__rations
relations92418333relations
rogations101510823rogations
rotations91613843rotations
ruinations1039603ruinations
saltations10310623saltations
salvations1338133salvations
sanctions1138873sanctions
satiations10312113satiations
sedations10311253sedations
sensations1059853sensations
sinuations1039413sinuations
solations9814623solations
stagnation1145543stagnation_
stations82415223_stations
sudations1039903sudations
tarnation9310093tarnation_
taxations1636863taxations
unctions1039733_unctions
urinations10310693urinations
vacations141910553vacations
vallations1339093vallations
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.423422437.4
2DLD Change Limit1486412017.12620859.0
3Display Results2012010.0932161.3
 (SQL Overall)1786912017.64223382.8
 
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.