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

227 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
cyanids1329793(None) 
canids95118131c_anids
cyanid123912041cyanid_
cyanide13298841cyanide
cyanides14258001cyanides
cyanins122910011cyanins
caids85226422c_a_ids
candids113812692c_andids
canid85526342c_anid_
cyanamids1743162cyanamids
cyanic133110772cyani_c
cyanided15254892cyanided
cyanin113911452cyani_n
cyanine122911512cyanine
cyanines132710542cyanines
cyanite122710762cyanite
cyanites132610162cyanites
cyans105714812cyan__s
cynics13377362cy_nics
ranids75118702_ranids
acarids105312243acarids
acids87121003__acids
agamids11317013agamids
aids57846353__a_ids
alands75418373alan_ds
alanins7315803alanins
amids85627513__amids
ands57833613__an_ds
anils56326723__anils
anis45746463__ani_s
aramids102810513aramids
araneids947743araneids
bands85233423_ban_ds
beanies93821093beanies
braids95015693bra_ids
brands95118943bran_ds
byrnies12378573byrnies
cabins104418923c_abins
caddis104613383c_addis
cadis84428503c_adi_s
cads76144523c_a__ds
caid77837533c_a_id_
cains75334303c_a_ins
cairds96411513c_airds
califs114915893c_alifs
canals84421663c_anals
canards10311203c_anards
candid104517853c_andid
candida114110253c_andida
candidas12338643c_andidas
candies104125613c_andies
candy115119823c_an_dy
caned85838093c_aned_
caners84629203c_aners
canes75350373c_an_es
canine83826703c_anine
canines93724033c_anines
caning94128623c_aning
cannas84518403c_annas
canoes84725883c_anoes
canons85522063c_anons
cans65050853c_an__s
cansos84915383c_ansos
cantos84826973c_antos
cants77036943c_an_ts
cantus85117763c_antus
canvas113813333c_anvas
capias10318353c_apias
capsids1239333capsids
carabids1338193carabids
carangids1344573carangids
cards85137933c_a_rds
caries85147623c_aries
carnies94123963carnies
caryatids1545223caryatids
catnips1195893catnips
caulds95512383c_aulds
cavies114525003c_avies
cavils114014393c_avils
cebids11439173c_ebids
ceboids1237653ceboids
chads116122233cha__ds
chaines124518733chaines
chains114819703cha_ins
chairs114916183cha_irs
chais107530313cha_i_s
chalcids1635893chalcids
chances145218093chances
changes134517583changes
changs125215373chan_gs
chanties132615803chanties
chants115020393chan_ts
chards125119733cha_rds
chytrids1744223chytrids
clads85722733cla__ds
claims105211573cla_ims
clangs95113613clan_gs
clanks124615183clan_ks
clans75031013clan__s
claries93422203claries
clerids1049093clerids
clinics11338743clinics
cnida878953c__nida
coatis85122603coati_s
coccids11277213coccids
conics103920593c_onics
conies84338593c_onies
conins84327233c_onins
conoids10813883conoids
corvids1337683corvids
cosmids1237633cosmids
craned96121653craned_
cranes84330753cran_es
crania82418433crani_a
cranial92114683cranial
craning103620303craning
cranium11911103cranium
craniums1297913craniums
cranks125015313cran_ks
crannies10313013crannies
crasis85020473crasi_s
crazies183413853crazies
crinoids1147363crinoids
cronies9622503cronies
cryonics1555413cryonics
cuboids1236723cuboids
cupids11369193c_upids
cuspids12427113cuspids
cyan96419623cyan___
cyanamid1644223cyanamid_
cyanamide1743343cyanamide
cyanamides1842953cyanamides
cyanate12259703cyanate
cyanates13238433cyanates
cyaniding1644803cyaniding
cyanitic1566323cyanitic
cyano105512493cyan__o
cyanoses1337423cyanoses
cyanosis1346273cyanosis
cycads14476213cy_cads
cycasins1545283cycasins
cyclins1438303cyclins
cycloids1647043cycloids
cyesis1148573cyesi_s
cygnets1333813cygnets
cymlins1436693cymlins
cymoid1459473cymoid_
cynic124712423cy_ni_c
cyprinids1742643cyprinids
cystoids14306733cystoids
danios7314603_danios
diacids1137863diacids
dyadics1453473dyadics
dyads10549973dya__ds
elands74914773elan_ds
elapids1036503elapids
eyelids1135943eyelids
gadids95611823_gadids
ganoids939333_ganoids
glands85314403glan_ds
grands84218243gran_ds
guanins8810013guanins
halids104016133_halids
hands95327383_han_ds
hyalins13229273hyalins
hyaloids1545993hyaloids
hybrids16236023hybrids
hydatids1643833hydatids
hydrids15267233hydrids
hyoids1377673hy_oids
iguanids1042913iguanids
kyanise14236143kyanise
kyanises15206393kyanises
kyanite14237313kyanite
kyanites15216683kyanites
kyanize23265343kyanize
kyanizes24205283kyanizes
lands65426903_lan_ds
maids86327143_ma_ids
manias84029033_manias
manics103919933_manics
mantids103113623_mantids
meanies93620743meanies
myasis114010473myasi_s
mysids1246563my_sids
oxyacids2162103oxyacids
ozalids1794063ozalids
panics103815363_panics
paynims1434973paynims
plaids94312443pla_ids
pyknics1842483pyknics
pyralids1445813pyralids
pyramids1645643pyramids
qaids156116313_qa_ids
raids65827513_ra_ids
rands65930453_ran_ds
ranid66429333_ranid_
ranis55235833_rani_s
rapids94913893_rapids
rynds9569973ry_n_ds
saids65328853_sa_ids
sands65228583_san_ds
sanies63031953_sanies
sayids104310973_sayids
sayyids14193833sayyids
sciaenids1242453sciaenids
sialids839723sialids
siganids1045303siganids
sparids103512123sparids
stands75118053stan_ds
synods1077953sy_nods
tabanids1144963tabanids
uranias72113813uranias
uranide82212093uranide
uranides92211283uranides
viands1047813vian_ds
wands96425483_wan_ds
wynds126310373wy_n_ds
yagis95416573_yagi_s
yairds10448023_yairds
yangs95618693_yan_gs
yanks125316573_yan_ks
yards95324613_ya_rds
yauds95013223_ya_uds
yids85224953_y__ids
yonis85020823_yoni_s
zanies153219673_zanies

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 Filter1786911340270.403443402.0
2DLD Change Limit1340272276.03322215.6
3Display Results2272270.0762986.8
 (SQL Overall)1786912276.51227440.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.