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

265 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
niacin831022(None) 
niacins938541niacins
diacid10310632diacid
diamin9312522diamin
diazin1639162diazin
ficin103516722fi_cin
ricin74620212ri_cin
abaci94718843abaci_
acacia10311353acacia
acid77533393__acid
acing87429153__acing
acini75718983__acini
actin74922553__actin
again65218123aga_in
agin56132713__agin
ain37579093__a_in
akin86328033__akin
alanin6317273alanin
amain74922913ama_in
amin66042253__amin
anilin6417793ani_lin
antacid10311223antacid
antiarin8413903antiarin
ayin76331743__ayin
bacon95620593_bacon
basin75026923_basin
beacon10511373beacon
biali73419073biali_
bialis83617163bialis
biasing103512453biasing
biffin14369103biffin
biggin103710603biggin
biotin83215833biotin
blain75421793bla_in
bracing123817613bracing
brain76229383bra_in
brucin1049133brucin
cabin94820943_cabin
cain65643913_ca_in
chain105723673cha_in
citrin82615413citrin
cocain101315013cocain
cyanin113911453cyanin
deacon9510423deacon
diacids1137863diacids
dialing94318173dialing
diamine10311983diamine
diamins10312213diamins
diapir9357113diapir
diazine1738933diazine
diazins1739183diazins
dicing105718763di_cing
dioxin14118783dioxin
disci85815023disci_
discing113914593discing
drain65222893dra_in
elain55324703ela_in
enfacing1467293enfacing
enlacing1148773enlacing
etamin81311853etamin
facia103218463_facia
facing125321573_facing
fagin9216573_fagin
fain75840563_fa_in
fiacre1137623fiacre
fibrin1138533fibrin
ficins113513983fi_cins
firkin1337823firkin
flacon1138633flacon
flavin1239303flavin
folacin1238053folacin
gaijin1445983gaijin
gain56042163_ga_in
gamin84423003_gamin
gittin72910553gittin
glacis94012133glacis
gliadin935593gliadin
glycin1235963glycin
gracing113216443gracing
gradin83517483gradin
grain65126253gra_in
gratin74520583gratin
guanin7610803guanin
hircine1239143hircine
hyalin122210043hyalin
icing86017753_i_cing
icon66922043_i_con
inaction1039623inaction
indamin1048043indamin
inlacing1158373inlacing
inulin6311733inulin
iodin64419353_iodin
isatin6412213isatin
kain85334293_ka_in
kinin94917323ki_nin
lacing94626233_lacing
lain46146283_la_in
lapin75222923_lapin
layin84720333_layin
leucin839113leucin
licit74327683li_cit
lignin74911193lignin
limacine1246003limacine
limacon1144143limacon
linin58025523li_nin
lipin75518893li_pin
macing114221553_macing
macon94519953_macon
main65345523_ma_in
matin75132853_matin
mavin105722953_mavin
mincing123314333mincing
mirin75023153mi_rin
miscoin11311433miscoin
mucin93116823_mucin
naan47621933n_a_an
nabis76020583n_abis
nacho105414383n_acho
nacre75715363n_acre
nadir61012973n_adir
naif76839023n_a_if
nail45838653n_a_il
nailing83419963nailing
naming93917893n_aming
nan37854883n_a__n
nandin7313033nandin
nankin1039673nankin
naoi46024633n_aoi_
napkin1236903napkin
narcein936293narcein
naric76824173n_aric
narine63422553n_arine
naris55735293n_aris
nasion63914083n_asion
nation64322803n_ation
nazi136219873n_azi_
nazis145216083n_azis
nearing83020333nearing
neaten64214543neaten
neocon836713neocon
nibbing12339553nibbing
nicad8312613ni_cad
nicads938333nicads
nice65534713ni_c_e
nicer74618293ni_cer
niche105016793ni_che
niching133612433niching
nick106627603ni_c_k
nicking143516323nicking
nicks114920493ni_cks
nicol71113293ni_col
nicotin948383nicotin
nidating1039783nidating
nidation9410583nidation
nidi56524403ni_di_
niding83217983ni_ding
niece74814503niec_e
nieces84112713nieces
nighing123410063nighing
nihil8410283ni_hil
nilling83619563nilling
nimbi94910313nimbi_
nimming12358143nimming
ninepin945573ninepin
ninon55517383ni_non
niobic1037243niobic
nipping123412873nipping
nisei54214353nisei_
niseis63512023niseis
nisi45823243ni_si_
nitchie1247233nitchie
nitid61817833ni_tid
niton55418283ni_ton
nitric82512063nitric
nitrid72812233nitrid
nitril62511533nitril
nitwit938593nitwit
nixie125114943ni_xie
nixing143311493ni_xing
noggin8288883noggin
nonacid101210843nonacid
nubbin10308293nubbin
nuncio837973nuncio
oilcan837793oilcan
orcin72716573_orcin
pacing114522753_pacing
pain65647243_pa_in
patin76832853_patin
pavin105623203_pavin
peacing124117073peacing
pian66136093pia__n
pianic103714123pianic
pidgin10259813pidgin
piecing12410453piecing
piggin103111093piggin
pinyin112710613pinyin
pipkin14248603pipkin
pippin92810303pippin
piscina1177043piscina
piscine11610973piscine
placid114012543placid
placing123815283placing
plain74823303pla_in
racing95030533_racing
racon75422143_racon
rain46251733_ra_in
raisin62716923raisin
ravin85624653_ravin
rawin85521473_rawin
reagin74915533reagin
ricing94822763ri_cing
ricins83618703ri_cins
sabin74924953_sabin
saimin8313663saimin
sain45551293_sa_in
sarin55239253_sarin
sasin54626573_sasin
satin55935223_satin
savin84625083_savin
sialic8313633sialic
sialid7314943sialid
siccan1037593siccan
siccing12319513siccing
simlin8311733simlin
siskin1079783siskin
slain54923573sla_in
spacing123614493spacing
spavin114210653spavin
stain55727943sta_in
statin63921473statin
swain84919053swa_in
tacit76333673_tacit
tain45548073_ta_in
takin94921303_takin
thiamin1236933thiamin
thiazin1945483thiazin
ticcing12308633ticcing
tiepin839343tiepin
tiffin12327933tiffin
tracing103720153tracing
train56529113tra_in
triacid1038593triacid
triazin1638203triazin
twain86313623twa_in
unakin10310963unakin
unlacing1148653unlacing
uracil8311543uracil
vain75233003_va_in
vialing113614163vialing
viatic11311453viatic
vicing124014243vi_cing
violin9311983violin
virgin1038083virgin
viscid1237473viscid
vitamin1237423vitamin
wain75840203_wa_in
wiccan1335033wiccan
wimmin1336153wimmin
wincing133413903wincing
within123611383within
zayin174512043_zayin
zeatin15412823zeatin
zincic1935903zincic
zincing192910283zincing
zircon1754953zircon

Search took 7 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.403443402.0
2DLD Change Limit1127162655.92319030.2
3Display Results2652650.0803312.5
 (SQL Overall)1786912656.40627894.3
 
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.