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

191 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
gothic123779(None) 
gothics1336121gothics
ethic101511222_ethic
glottic1036652glottic
gnathic1344842gnathic
goth86825082goth__
gothite1146402gothite
goths96513002goth_s
lithic1139492lithic
lotic76420672lot_ic
mythic1637272mythic
otic66624822_ot_ic
agonic93515143ago_nic
anorthic1346973anorthic
antic75728863ant_ic
aortic8316613aortic
argotic10310283argot_ic
atomic104115603atomic
atonic83420473atonic
atopic103514143atopic
attic75618353_attic
azotic172711633azot_ic
benthic1437473benthic
bioethic1544693bioethic
biotic103816613biot_ic
boric98024223bo_ric
botanic1159583botanic
both96533433both__
bother115218063bother
bothies12414783bothies
bothria1246443bothria
bothy136713963both_y
chic115925203__chic
citric102812313citric
coccic8298943coccic
cochin131313203cochin
colic95726173co_lic
comic114721813co_mic
conic95329793co_nic
cosmic12410343cosmic
couthie121810553couthie
domic104317243do_mic
doth86225713doth__
eolithic1375853eolithic
erethic1257723erethic
ergotic1049723ergot_ic
erotic82620273erot_ic
ethics11169283_ethics
ethnic1148853_ethnic
etic66123953_et_ic
exotic153112653exot_ic
folic105319323fo_lic
formic13310453formic
gallic9411643gallic
gamic103916203g_amic
garlic9310043garlic
gastric1038633gastric
gather104115853gather
genic85119393g_enic
geodic1048003geodic
georgic1144293georgic
gestic9312773gestic
ghi77019883g__hi_
ghis85020163g__his
gittin72910553gittin
glochid1445263glochid
glottis837173glottis
glyphic1844063glyphic
gnomic11248593gnomic
gnostic1038433gnostic
goalie7413163goalie
goblin939503goblin
godship1445083godship
godwit1137513godwit
goethite1244053goethite
gonadic1177213gonadic
gonia64117533go_nia
gonidic1166103gonidic
gonif94320923go_nif
goodie83613993goodie
goonie73615563goonie
gopher1239183gopher
gopik1257533go_pik
gorhen1038893gorhen
gosh86123423gosh__
gossip946433gossip
got49870443got___
gotcha1234633gotcha
gotchas1334613gotchas
gothicism1743793gothicism
gothicize2443623gothicize
gothites1246013gothites
gotten73410113gotten
goyim1148603go_yim
graphic1537353graphic
hic86540563___hic
holmic1338783holmic
hottie92514383hottie
iatric8312163iatric
ictic9311803ict_ic
iodic84816753io_dic
ionic74622663io_nic
isthmic1444793isthmic
lathi85417203lathi_
lathis95516173lathis
lithia939333lithia
lochia1158313lochia
logic88217833lo_gic
loth76132133loth__
loti46431843lot_i_
lytic104513033lyt_ic
metric10314673metric
miotic103715753miot_ic
morphic1648693morphic
mosaic10311143mosaic
moth96731333moth__
mother113718643mother
mothier121910213mothier
moths106021553moth_s
mothy136214553moth_y
motif10519683mot_if
motific1446323motific
motivic1445163motivic
motoric11312223motoric
myotic133112313myot_ic
nitric82512063nitric
noetic8514043noetic
nordic939473nordic
nother93815963nother
nothing113511903nothing
notice8313443not_ice
odic74920573_o_dic
ohia75719363_o_hia
ohmic1237833_ohmic
oleic7313333_oleic
ontic74418573_ontic
ootheca1244003ootheca
ootid61416703oot_id
optic93715183_optic
orgic8311823_orgic
orphic1368323orphic
osmic939913_osmic
other84219103_other
otitic83112683_otitic
outhit92818473outhit
photic133316443phot_ic
poetic10416843poetic
potamic13310853potamic
pother113818853pother
pothos114214693pothos
potpie103412433potpie
potsie83916033potsie
ptotic102713373ptotic
rhotic112711233rhot_ic
roshi8310753roshi_
roshis9311793roshis
roti46332933rot_i_
rotis56327063rot_is
sodic84917493so_dic
sonic75225293so_nic
sorbic10310393sorbic
soth75932523soth__
soths86218633soth_s
spathic1437543spathic
stoic7317253_stoic
thick145613353__thick
thin76732393__thin
thio77225413__thio
thir76420543__thir
this76027383__this
tic56343463__t_ic
toluic837693toluic
tonic74727653to_nic
tophi105215303tophi_
topic95721503to_pic
toric76529313to_ric
totemic1137533totemic
tother94117143tother
toxic145315623to_xic
trophic14311033trophic
unchic1338643unchic
vatic10316423vat_ic
vitric112510113vitric
voltaic1245453voltaic
within123611383within
xanthic1945863xanthic
yogic116114933yo_gic
yonic105920843yo_nic
yttric1145433yttric
zoic152316073zo__ic
zygotic2254663zygot_ic

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161914.70323966.8
3Display Results1911910.0464152.2
 (SQL Overall)1786911915.13934771.6
 
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.