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

183 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
agnatic1031097(None) 
acmatic13311692acmatic
agamic113110562ag_amic
agaric93513632ag_aric
agenetic1138202agenetic
aggadic1254812aggadic
agnail739532agna_il
agnate73314882agnat_e
agnates82813192agnates
agnatical1246162agnatical
agnation9311722agnation
agnostic1146712agnostic
agravic1345892agravic
antic75728862a_n_tic
aquatic1838112aquatic
astatic9514192astatic
aviatic1239242aviatic
enatic8317562_enatic
fanatic12610692fanatic
gnathic1344842_gnathic
ignatia846132ignatia
lunatic938752lunatic
magmatic1548392magmatic
magnetic1349232magnetic
venatic12311522venatic
abatis84317933a_batis
abiotic11510463abiotic
acetic10314503a_cetic
aconitic1239533aconitic
acrotic112515543acrotic
adnate72913483adnat_e
adnation9310783adnation
adynamic1643343adynamic
again65218123ag_a_in
agamid103710693ag_amid
agapeic1244713agapeic
agarics10319943ag_arics
agate66525153ag_at_e
agates76121343ag_ates
agatize1739833ag_atize
agatoid948623ag_atoid
agnails837003agnails
agnations10310033agnations
agnosia837643agnosia
agnostics1244463agnostics
agonic93515143ag_onic
agonistic1246683agonistic
agouti7388773agouti_
agoutis8286873agoutis
agraphic1646183agraphic
agrestic1147923agrestic
akinetic1455953akinetic
albitic1139133albitic
alcaic1039983alca_ic
alkalic13146973alkalic
aloetic9313183aloetic
amnesic1137183amnesic
amnestic1247053amnestic
amnic95516243amn__ic
amniotic1246403amniotic
anabatic1247443anabatic
anaemic1149903a_naemic
analytic1348183a_nalytic
anatomic1258673a_natomic
anatto6139913a_natto
anemic102713693a_nemic
angaria8311583angaria
angelic1039623angelic
anisic8313793a_nisic
annates72415423annates
annatto7144153annatto
anodic92813133a_nodic
anomic102516303a_nomic
anoxic152610673a_noxic
anti45536363a_n_ti_
antick124814583a_n_tick
antics84621453a_n_tics
antis55033313a_n_tis
anuric8812103a_nuric
aortic8316613a_ortic
aphasic142810063aphasic
aphetic142912853aphetic
aphotic142913123aphotic
aplanatic1344903aplanatic
aplastic1249243aplastic
aplitic11311743aplitic
apneic1078623apn_eic
apnoeic1147613apnoeic
apractic1448303apractic
apraxic1846293apraxic
aprotic112715243aprotic
aquatics1945893aquatics
arabic10312733a_rabic
arctic10313513a_rctic
argentic1149023argentic
argotic10310283argotic
arnatto7145073arnatto
aromatic12315633aromatic
ascetic11310063ascetic
ascitic1139323ascitic
aseptic1137373aseptic
atactic11410083atactic
atavic11189293a_tavic
ataxic15169203a_taxic
atretic9313923atretic
attic75618353a__ttic
augitic1038283augitic
auntie64317703aun_tie
auxetic1637143auxetic
azotic172711633a_zotic
cannabic1474913cannabic
cantic103920543can_tic
caryatic1548493caryatic
comatic131816933comatic
cuneatic1245853cuneatic
dalmatic1348683dalmatic
dogmatic1447623dogmatic
dunitic1048143dunitic
dynamic1545813dynamic
dynastic1445853dynastic
ectatic11310123ectatic
erratic9311113erratic
fanatics1367183fanatics
frantic12310363frantic
galactic13106533galactic
gametic1239993gametic
gamic103916203_g_amic
genetic101211783genetic
gestic9312773_gestic
gigantic1244303gigantic
gnat56034433_gnat__
gnats65217713_gnat_s
gnatty10336483_gnatty
gnomic11248593_gnomic
gnostic1038433_gnostic
gonadic1177213gonadic
gratin74520583_gratin
gratis74819243_gratis
haematic151310213haematic
hagadic1445863hag_adic
haggadic1643073haggadic
hematic141816743hematic
hepatic141712773hepatic
ignatias944913ignatias
kenotic1359713kenotic
kinetic13209173kinetic
lentic83515743len_tic
lignitic1146393lignitic
lunatics1045473lunatics
maenadic1344613maenadic
magnate10512703magnat_e
magnates11511613magnates
magnesic1345753magnesic
magnetics1447163magnetics
magnific1654213magnific
manganic1346993manganic
mannitic1248013mannitic
mantic104120903man_tic
monadic1268883monadic
monastic1249863monastic
naric76824173__naric
nastic82915973__nastic
nematic111713993nematic
oghamic1544043oghamic
ontic74418573_on_tic
osmatic11179983osmatic
phatic133014413_phatic
piratic11314293piratic
pragmatic1647633pragmatic
psoatic1139303psoatic
quantic18279063quantic
sabbatic1445323sabbatic
sciatic11910173sciatic
sematic111716873sematic
somatic111916463somatic
sonantic1048273sonantic
static83118683_static
synaptic1546283synaptic
tonetic9313433tonetic
uratic83016353_uratic
vanadic1336743vanadic
vatic10316423__vatic
viatic11311453_viatic

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 Filter1786911340270.500357382.0
2DLD Change Limit1340271836.76619808.9
3Display Results1831830.0632904.8
 (SQL Overall)1786911837.32924381.4
 
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.