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

251 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
niacins93854(None) 
niacin8310221niacin_
diacids1137862diacids
diamins10312212diamins
diazins1739182diazins
ficins113513982fi_cins
ricins83618702ri_cins
acacias11510403acacias
acids87121003__acids
acing87429153__acing
acini75718983__acini
acinus8311253__acinus
actins86321103__actins
aiblins9311473aiblins
ains46158883__a_ins
alanins7315803alanins
amins75534323__amins
anilins7416793ani_lins
animacies1348593animacies
antacids1148333antacids
antiarins9413893antiarins
ayins85321613__ayins
bacons104917583_bacons
basins85722763_basins
beacons11410733beacons
bialies93618413bialies
bialis83617163biali_s
biasing103512453biasing
biffins15358533biffins
biggins113410693biggins
biotins93114453biotins
blains84516373bla_ins
bracing123817613bracing
bracings13369293bracings
brains85125473bra_ins
brucins1158003brucins
cabins104418923_cabins
cains75334303_ca_ins
chains114819703cha_ins
citrins92614363citrins
cocains111313923cocains
cyanins122910013cyanins
deacons10310393deacons
diacid10310633diaci_d
dialing94318173dialing
dialings10329823dialings
diamin9312523diamin_
diamine10311983diamine
diamines11311643diamines
diapirs10347643diapirs
diaries83321953diaries
diazin1639163diazin_
diazine1738933diazine
diazines1838713diazines
dicing105718763di_cing
dioxins1568003dioxins
discing113914593discing
drains73719403dra_ins
elains64919853ela_ins
enfacing1467293enfacing
enlacing1148773enlacing
etamins91511833etamins
facias113415803_facias
facies113921593_facies
facing125321573_facing
facings134511263_facings
fagins10513863_fagins
fiacres1237253fiacres
fibrins1238633fibrins
ficin103516723fi_cin_
firkins1437663firkins
flacons1238053flacons
flavins1338543flavins
folacins1337203folacins
gains65729513_ga_ins
gamins94420043_gamins
glacis94012133glaci_s
gliadins1035193gliadins
glycins1335563glycins
gracing113216443gracing
gradins93416233gradins
grains74223093gra_ins
gratins84119183gratins
guanins8810013guanins
hircine1239143hircine
hyalins13229273hyalins
icing86017753_i_cing
icings9428453_i_cings
icons76516493_i_cons
inactions1139323inactions
indamins1147603indamins
inlacing1158373inlacing
inulins7311493inulins
iodins74216523_iodins
isatins7310773isatins
kains96125643_ka_ins
kinins104014583ki_nins
lacing94626233_lacing
lacings105013653_lacings
lapins84520683_lapins
layins93817653_layins
leucins938103leucins
lignins84010493lignins
limacine1246003limacine
limacons1243953limacons
linins65922143li_nins
lipins85016883li_pins
macing114221553_macing
macons104017243_macons
mains75635113_ma_ins
matins84527783_matins
mavins115119183_mavins
mincing123314333mincing
mirins83918903mi_rins
miscoins12311083miscoins
mucins102712513_mucins
naans55815253n_a_ans
nabis76020583n_abi_s
nachas114914193n_achas
naches114622413n_aches
nachos115014183n_achos
nacres85614453n_acres
nadirs7109003n_adirs
naifs87617423n_a_ifs
nailing83419963nailing
nails55730403n_a_ils
naming93917893n_aming
nancies93516843nancies
nandins8312003nandins
nankins1159053nankins
nans46139403n_a__ns
napkins1336673napkins
narceins1036413narceins
narine63422553n_arine
naris55735293n_ari_s
nasions73112383n_asions
nations74720563n_ations
navies95218623n_avies
nazis145216083n_azi_s
nearing83020333nearing
neatens73310403neatens
neocons936913neocons
nibbing12339553nibbing
nicads938333ni_cads
niches114419143ni_ches
niching133612433niching
nicking143516323nicking
nicks114920493ni_c_ks
nicols8810243ni_cols
nicotins1058173nicotins
nidating1039783nidating
nidations1039213nidations
niding83217983ni_ding
nieces84112713niec_es
nifties102612503nifties
nighing123410063nighing
nihils937573ni_hils
nilling83619563nilling
nimming12358143nimming
ninepins1045873ninepins
ninnies73713613ninnies
ninons64913773ni_nons
nipping123412873nipping
niseis63512023nisei_s
nitchies1339073nitchies
nitons64614903ni_tons
nitrids8269633nitrids
nitrils72810703nitrils
nitwits1035053nitwits
nixies135313873ni_xies
nixing143311493ni_xing
noggins9288453noggins
nonacids11148263nonacids
nubbins11268023nubbins
nuncios937113nuncios
oilcans936813oilcans
orcins83313433_orcins
pacing114522753_pacing
pains75138283_pa_ins
patins87528783_patins
pavins114919663_pavins
peacing124117073peacing
pians75126963pia__ns
pidgins11259123pidgins
piecing12410453piecing
piecings1345343piecings
piggins113010473piggins
pipkins15328183pipkins
pippins10319753pippins
piracies12312643piracies
piscina1177043piscina
piscinas1275483piscinas
piscine11610973piscine
placing123815283placing
plains85019593pla_ins
racing95030533_racing
racings105015133_racings
racons84319343_racons
rains55140233_ra_ins
raisins72715343raisins
ravins94622563_ravins
rawins95617623_rawins
reagins84215643reagins
ricin74620213ri_cin_
ricing94822763ri_cing
ricinus9408123ri_cinus
sabins85521983_sabins
saimins9312113saimins
sains55639973_sa_ins
sarins63932623_sarins
sasins64923103_sasins
satins64930483_satins
savins93923133_savins
sialids839723sialids
siccing12319513siccing
simlins9311843simlins
siskins1159583siskins
spacing123614493spacing
spacings13287043spacings
spavins12419323spavins
stains64923653sta_ins
statins73719773statins
swains94513953swa_ins
tains54936323_ta_ins
takins105117403_takins
thiamins1346633thiamins
thiazins2045313thiazins
ticcing12308633ticcing
tiepins939463tiepins
tiffins13327983tiffins
tracing103720153tracing
tracings112910413tracings
trains64725343tra_ins
triacids1146723triacids
triazins1738353triazins
twains95811183twa_ins
unlacing1148653unlacing
uracils939373uracils
vialing113614163vialing
vicing124014243vi_cing
violins10311453violins
virgins1137863virgins
vitamins1347083vitamins
wains86930873_wa_ins
wiccans1434603wiccans
wincing133413903wincing
withins133511693withins
zayins18409713_zayins
zeatins16311733zeatins
zincing192910283zincing
zircons1854963zircons

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.470380193.6
2DLD Change Limit1340272517.42018062.9
3Display Results2512510.0803137.5
 (SQL Overall)1786912517.97022420.5
 
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.