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

283 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
diacid1031063(None) 
diacids1137851diacids
acid77533392__acid
diacidic1444052diacidic
dialed84716452dialed
diamide1138472diamide
diamin9312512diamin
diapir9357112diapir
diapsid1146702diapsid
diazin1639162diazin
diced95824682di_ced
dioxid1568392dioxid
disced104914652disced
disci85815022disci_
discoid11311242discoid
niacin8310222niacin
placid114012542placid
sialid7314932sialid
triacid1038582triacid
viscid1237472viscid
abaci94718843abaci_
acacia10311353acacia
acarid95017063acarid
aced79540883__aced
acids87121003__acids
acidy117214893__acidy
acrid86920103__acrid
agamid103710673agamid
aid49269073__a_id
alcid85817963_alcid
amid77036343__amid
antacid10311203antacid
aramid93315603aramid
arid57642713__arid
avid88325963__avid
biali73419073biali_
bialis83617163bialis
biased94012223biased
bifid11910703bi_fid
biocide1237323biocide
braced115420603braced
braid85822263bra_id
caid77837533_ca_id
canid85526343_canid
chalcid1537873chalcid
coccid102910743coccid
cyanid123912033cyanid
dace76934923d_ac_e
daces85030683d_aces
dacha114812573d_acha
dacite91115883d_acite
dacoit9415443d_acoit
dad58456163d_a__d
daimio937463daimio
dais57040703d_a_is
daisied93410013daisied
danced105315253danced
danio6319783d_anio
dared75935013d_ared
daric85623113d_aric
dated75530993d_ated
davit93424593d_avit
dawed106222813d_awed
dazed165919363d_azed
deacon9510423deacon
dead65434243dea__d
deair65817193dea_ir
deaned84620453deaned
dearie73319813dearie
deasil71110983deasil
deaved114916553deaved
decide104116873d_ecide
defaced142910973defaced
deiced104214483deiced
deicide1149403deicide
desmid1048363desmid
deuced104112123deuced
devoid1189353devoid
diadem1037583diadem
dial55935063dia__l
dialer74315433dialer
dialing94318173dialing
dialist8517763dialist
dialled9510133dialled
dialog837973dialog
dials64925343dia_ls
diamides1238813diamides
diamine10311973diamine
diamins10312203diamins
diamond1186113diamond
diaper94513113diaper
diapirs10347643diapirs
diapsids1244753diapsids
diarchic1645613diarchic
diarchy1644673diarchy
diaries83321953diaries
diarist8517113diarist
diary95016973dia_ry
diatom939453diatom
diazine1738933diazine
diazins1739183diazins
diazo15310033dia_zo
dibasic1246033dibasic
dibbed124713473dibbed
dicast9315573dicast
dice75841893di_c_e
dicer85426423di_cer
dices86434243di_ces
dicey114819333di_cey
dicier94416233di_cier
dicing105718763di_cing
dick116432383di_c_k
dicked144920863dicked
dickie133913113dickie
dicks125824693di_cks
dicky154816243di_cky
dicot85429093di_cot
dicta84915633di_cta
dicty115116293di_cty
did56850513d___id
didact10711203didac_t
didactic1445183didactic
didacts1186063didacts
didie74120563di_die
died66137853di__ed
diesis74013493diesis
dieted83115493dieted
digged104314653digged
digit73825273di_git
dikdik1152613dikdik
diked115024683di_ked
dilated93115823dilated
dilled84122223dilled
dimmed124110323dimmed
dimwit1237953dimwit
dined76431993di_ned
dinged95221783dinged
dinked124818353dinked
dinned84317613dinned
dinted84419843dinted
dioxide1656303dioxide
dioxids1655683dioxids
dioxin14118783dioxin
diploid11310283diploid
dipped123517493dipped
dirked124912273dirked
dirled84514903dirled
dirtied93210853dirtied
disbud10165713disbud
disc76123233disc__
discard11310213discard
discing113914593discing
disco85616073disc_o
discoed11312483discoed
discoids1239873discoids
discord1139993discord
discos94915213discos
discs85316263disc_s
discus94512113discus
dished114318713dished
disked125015763disked
dissed85220183dissed
distil73616433distil
ditch115015093ditc_h
ditched143711903ditched
dived106321373di_ved
divide113410893di_vide
divvied1544813divvied
dixit134420593di_xit
dizzied17236133dizzied
doated84118183doated
dolci84912603dolci_
drachm1436493drachm
drail65020973dra_il
drain65222893dra_in
draped105314363draped
drayed115911393drayed
droid74218533d_roid
druid74111323d_ruid
duad66521413dua__d
duci76422623d_uci_
dyad96415453dya__d
dyadic1336093dyadic
elapid939543elapid
faced117727653_faced
facia103218463_facia
fiacre1137623fiacre
ficin103516723fi_cin
flaccid1544393flaccid
gadid85517373_gadid
glacis94012133glacis
graced105217903graced
gravid113710973gravid
halid94424973_halid
hispid1238173hispid
hydracid1844973hydracid
iced78721893_i_ced
imid76122293_i_mid
iodid74315533_iodid
irid55927173_i_rid
kidvid1535023kidvid
laced87132643_laced
laid56439143_la_id
lianoid837523lianoid
liard65418593lia_rd
licit74327683li_cit
limpid11389753limpid
lipid85916173li_pid
lipoid9411043lipoid
liquid1637143liquid
livid96714423li_vid
lucid84314573_lucid
maced108528693_maced
maid75537643_ma_id
medicaid1445773medicaid
minced114114913minced
misdid10510563misdid
monacid121310223monacid
mucid104115253_mucid
muscid11219833muscid
niacins938543niacins
nicad8312613ni_cad
nitid61817833ni_tid
nitrid72812233nitrid
nonacid101210843nonacid
oxyacid2062763oxyacid
ozalid1696673ozalid
paced106931683_paced
paid75737483_pa_id
pavid115717003_pavid
peaced115818913peaced
peracid12312993peracid
pianic103714123pianic
pieced113912103pieced
placed114318003placed
placoid1239763placoid
plaid85118303pla_id
psocid1137253psocid
qaid146023843_qa_id
rabid84520783_rabid
raced87635313_raced
raid55243073_ra_id
rancid9513863rancid
ranid66429333_ranid
rapid86422033_rapid
riced85825543ri_ced
ricin74620213ri_cin
rigid7913893ri_gid
said55742113_sa_id
saiyid10167413saiyid
sapid84720933_sapid
sayid95516723_sayid
sialic8313633sialic
sialids839723sialids
sialoid8310953sialoid
sicced11489653sicced
siganid947183siganid
spaced114517253spaced
sparid94016933sparid
staid66722073sta_id
subacid1248473subacid
tabid84418263_tabid
tacit76333673_tacit
ticced11438443ticced
timid84815723ti_mid
tineid74412013tineid
traced94821583traced
triacids1146713triacids
uracil8311543uracil
valid94618383_valid
vapid115614283_vapid
vialed105112593vialed
viand9511073via_nd
viatic11311453viatic
viced115118183vi_ced
virid94116043vi_rid
viroid10411523viroid
viscoid1337023viscoid
vivid125112313vi_vid
winced124415343winced
zinced18419413zinced
zincic1935903zincic
zincoid1946663zincoid

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.1431249587.4
2DLD Change Limit1127162835.25021469.7
3Display Results2832830.0933043.0
 (SQL Overall)1786912835.48632572.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.