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

178 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
fanatic1261069(None) 
fanatics1367181fanatics
agnatic10310972agnatic
antic75728862_an_tic
cantic103920542can_tic
enatic8317562_enatic
fanatical1446482fanatical
fanfic1436312fan_fic
fantail10310232fantail
fantastic1446142fantastic
faradic1337692faradic
frantic12310362fran_tic
lunatic938752lunatic
mantic104120902man_tic
vanadic1336742vanadic
venatic12311522venatic
abatis84317933_abatis
acetic10314503_acetic
acmatic13311693acmatic
agamic113110563_agamic
agaric93513633_agaric
anabatic1247443anabatic
anaemic1149903_anaemic
analytic1348183_analytic
anatomic1258673_anatomic
anatto6139913_anatto
anemic102713693_anemic
anisic8313793_anisic
anodic92813133_anodic
anomic102516303_anomic
anoxic152610673_anoxic
anti45536363_an_ti_
antick124814583_an_tick
antics84621453_an_tics
antis55033313_an_tis
anuric8812103_anuric
aortic8316613_aortic
aplanatic1344903aplanatic
aquatic1838113aquatic
arabic10312733_arabic
arctic10313513_arctic
astatic9514193astatic
atactic11410083_atactic
atavic11189293_atavic
ataxic15169203_ataxic
attic75618353_a_ttic
aviatic1239243aviatic
azotic172711633_azotic
banausic1242823banausic
barytic1437823barytic
basaltic1245153basaltic
canakin131810833canakin
cannabic1474913cannabic
canonic11312933canonic
canopic1338803canopic
caryatic1548493caryatic
caustic1139753caustic
comatic131816933comatic
cuneatic1245853cuneatic
cyanitic1566323cyanitic
cyanotic1546623cyanotic
dalmatic1348683dalmatic
dramatic1369423dramatic
dunitic1048143dunitic
dynamic1545813dynamic
dynastic1445853dynastic
ectatic11310123ectatic
erratic9311113erratic
fabric1337833fa_bric
fanaticism1754633fanaticism
fanaticize2453733fanaticize
fanfics1535173fan_fics
fantails1139693fantails
fantasia1197013fantasia
fantasie11117743fantasie
fantasm1236593fantasm
fantast10311703fantast
fantastico1553383fantastico
fantastics1544373fantastics
fantasy1336153fantasy
fantod102010033fan_tod
fantom112110803fan_tom
faradaic1443653faradaic
fatidic1345723fatidic
faunistic1444473faunistic
finalis103313663finalis
fistic11812573f_istic
fixatif2054633fixatif
frenetic1346293frenetic
fumaric1446303fumaric
fundic12389083fun_dic
fungic12387813fun_gic
fustic11910633f_ustic
galactic13106533galactic
gametic1239993gametic
genetic101211783genetic
gnathic1344843_gnathic
gonadic1177213gonadic
granitic1168623granitic
haematic151310213haematic
hagadic1445863hagadic
halakic1656663halakic
hanseatic1444553hanseatic
haptic13511893ha_ptic
hematic141816743hematic
hepatic141712773hepatic
ignatia846133ignatia
jaditic1746703jaditic
jalapic1844543jalapic
karstic1357983karstic
kenotic1359713kenotic
kinetic13209173kinetic
lactic10713493la_ctic
lanai5319573lana_i_
lanais6316793lana_is
lanate6421263lanat_e
lanated8313203lanated
lentic83515743len_tic
lunatics1045473lunatics
maenadic1344613maenadic
magmatic1548393magmatic
magnetic1349233magnetic
manakin131810643manakin
manat76039993manat__
manatee9317663manatee
manatoid1148823manatoid
manats84623463manat_s
mandalic1347803mandalic
manganic1346993manganic
manic94629443man__ic
mannitic1248013mannitic
mantid93820383man_tid
mantis83926033man_tis
mantric11311343mantric
mastic103119173ma_stic
monadic1268883monadic
monastic1249863monastic
naric76824173__naric
nastic82915973na_stic
nematic111713993nematic
ontic74418573_on_tic
osmatic11179983osmatic
pancratic1546353pancratic
panic93923903pan__ic
panoptic1447183panoptic
pantie84326473pan_tie
paretic113016673paretic
parotic112518043parotic
phatic133014413_phatic
piratic11314293piratic
psoatic1139303psoatic
qanat144426843qanat__
qanats154112813qanat_s
quantic18279063quan_tic
sabbatic1445323sabbatic
sanative11310473sanative
santalic1048893santalic
santir6315253san_tir
satanic939933satanic
sciatic11910173sciatic
sematic111716873sematic
somatic111916463somatic
sonantic1048273sonantic
static83118683_static
synaptic1546283synaptic
tabetic1138463tabetic
tactic10612753ta_ctic
tannic82811473tan_nic
tantalic1048053tantalic
tantric939583tantric
taxitic1637093taxitic
tonetic9313433tonetic
uranitic10148683uranitic
uratic83016353_uratic
vandalic1446113vandalic
vatic10316423__vatic
viatic11311453_viatic
xanthic1945863xanthic

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.406440125.6
2DLD Change Limit1340271786.71619956.4
3Display Results1781780.0632825.4
 (SQL Overall)1786911787.18524870.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.