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

257 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
charnels1332817(None) 
channels13388501channels
charnel124010051charnel_
cannels93413362c_annels
carcels114516062c_arcels
carnets93918402c_arnets
carneys124310542c_arneys
carpels115315462c_arpels
carrels95117302c_arrels
cartels94618122c_artels
carvels124914592c_arvels
chaines124518732chaine_s
chancels15439092chancels
channel123910492channel_
chapels14429152cha_pels
chares115631802char_e_s
chargers144011322chargers
charges134615982charge_s
chariness14310062chariness
charleys1695632charleys
charmers154211332charmers
charters134115582charters
chattels13286792chattels
chunnels13304562chunnels
churners13316892churners
cornels94716662c_ornels
darnels83710432_darnels
harness102413932_harness
ariels65119373__ariels
artels66216233__artels
barbels114514433_barbels
barneys12569563_barneys
barrels94514363_barrels
bharals1236733bhar_als
blarneys13183193blarneys
camels105217083c_a_mels
canals84421673c_a_nals
cancels114113313c_ancels
caners84629203c_a_ners
canes75350373c_a_ne_s
cannel84216403c_annel_
canners93822663c_anners
caramels1238803c_aramels
caravels1337443c_aravels
carcel105018673c_arcel_
carders104820353c_arders
careens94514703c_areens
careers95218783c_areers
carers85133963c_ar_ers
cares77369183c_ar_e_s
caress85720263c_ar_ess
carets85330773c_ar_ets
carfuls1249133c_arfuls
caries85147623c_arie_s
carles85435083c_arle_s
carless95118493c_arless
carls77037423c_ar__ls
carnal83919213c_arnal_
carnet84732873c_arne_t
carney115315703c_arne_y
carnies94123963c_arnies
carns75937563c_arn__s
carols85124983c_ar_ols
carpals113414633c_arpals
carpel105418473c_arpel_
carpers114521253c_arpers
carpets113915333c_arpets
carrel84718633c_arrel_
carrell94610473c_arrell
carrells10359273c_arrells
carses85233653c_arse_s
cartel85022533c_artel_
carters95327253c_arters
cartes86239473c_arte_s
carvel114817573c_arvel_
carvers124817543c_arvers
carves115128453c_arve_s
chadless1436403chadless
chaebols1544723chaebols
chafers154512743cha_fers
chafes145017913cha_fe_s
chaffers19378003chaffers
chaine115119223chaine__
chained133812693chaine_d
chains114819703chain__s
chaises124317493chaise_s
chalehs15268803cha_lehs
chalets122813473cha_lets
chalones13312173chalone_s
chambers173410623chambers
chamfers18409223chamfers
champers173311623champers
chancel144011783chancel_
chancers154313493chancers
chances145218093cha_nces
changers144313203changers
changes134517583cha_nges
changs125215373cha_n_gs
channeled1544913channeled
channeler1444603channeler
channelers1543853channelers
chanters134016743chanters
chanteys16387493chanteys
chants115020393cha_n_ts
chaoses124715123chaose_s
chapel134911373cha_pel_
chapes135421873cha_pe_s
chaplets1556883chaplets
chapters154012133chapters
charades141310853charades
charas114223613char__as
charases131312763charases
charcoals16174683charcoals
chards125119733char__ds
chare105231983char_e__
chared125423693char_e_d
charge125114213charge__
charged144614023charge_d
charger133914063charge_r
charier124317903charie_r
chariest13315513chariest
charily15310283char_ily
chariots1339393chariots
charisms15710263charisms
charkas164810963char_kas
charked174814013charke_d
charkhas20285023charkhas
charks155219703char__ks
charley15118273charle_y
charlies133414233charlies
charmed154714253charme_d
charmer144913663charme_r
charmeuse1642593charmeuse
charmless1633583charmless
charms135218843char__ms
charpais1536933charpais
charpoys1834533charpoys
charquis2243933charquis
charred134614493charre_d
charros124312153char_ros
charrs115219193char__rs
chars105936643char___s
charted135116853charte_d
charter123918303charte_r
chartless1435703chartless
charts115823093char__ts
chasers123714923cha_sers
chases115128233cha_se_s
chasses124017503chasse_s
chastely1635813chastely
chastens13429183chastens
chattel12388893chattel_
chatters134213953chatters
chaufers16347303chaufers
chaunters1455823chaunters
chaunts1267083chaun_ts
chawers154412053cha_wers
chazzens21253943chazzens
cheapness1643743cheapness
chervils1644553chervils
chicness1535593chicness
chiels115115933ch__iels
chimneys1883643chimneys
chines115029173ch_ine_s
chirpers15358133chirpers
chirres123812253chirre_s
chisels12219103ch_isels
chorales133712883chorales
chorals124614113chor_als
choreas124414203chor_eas
chores114828023chor_e_s
chorines132917253chorine_s
chortens13308793chortens
chortles133611323chortles
chunnel12395313chunnel_
churls115411073chur__ls
churned13358373churne_d
churner12298343churne_r
churns114910233churn__s
chutnees1343963chutnees
chutneys1642323chutneys
clarets94111103clar_ets
claries93422203clarie_s
clarinets1137683clarinets
claroes93113743claroe_s
clearness1135633clearness
coarsely1335533coarsely
coarsens10348123coarsens
colonels104210463colonels
corbels113813593c_orbels
cormels113813373c_ormels
corneas94717003c_orneas
cornel84020053c_ornel_
corners94723313c_orners
cornets94820573c_ornets
coronels104012153coronels
cracknels1743433cracknels
cranes84330753cra_ne_s
creels84416943c__reels
crenels93711013c_renels
darnel74312183_darnel_
darners83815773_darners
dearness939973dearness
dharnas1155373dharn_as
earners74016453_earners
fardels11389893_fardels
farfels13348213_farfels
farness102912203_farness
flannels1134843flannels
garners83815983_garners
garnets84115403_garnets
gharials1245123gharials
grapnels1134393grapnels
hairnets1195633_hairnets
hallels103310133_hallels
hansels104011663_hansels
hardens113815023_hardens
hardness122411083_hardness
hareems12428203_hareems
harems115513823_har_ems
hares86255543_har_e_s
harkens144112863_harkens
harls85634503_har__ls
harmers124116593_harmers
harpers124916203_harpers
hartals10313023_hartals
hassels104311023_hassels
hazels185710083_ha_zels
hirsels10128353_hirsels
hornets104113553_hornets
hornfels1443793_hornfels
kernels11417953_kernels
learners8398153learners
marcels113212373_marcels
marvels123810093_marvels
nearness838313nearness
panels84716523_pa_nels
parcels113712663_parcels
parrels94713493_parrels
quarrels1735083quarrels
rechannels1543183rechannels
scrannels1143513scrannels
sharers104720623shar_ers
shares95236413shar_e_s
sharkers154011053sharkers
sharns95516983sharn__s
sharpens13377813sharpens
sharpers133810943sharpers
sharpness1434943sharpness
thanes94918983tha_ne_s
thermels13607763thermels
unharness1245253unharness
warners103315563_warners
wharves16457143wharve_s
whatness1435093whatness
yarners104312203_yarners
yearners11346373yearners

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 Filter1786911461620.453394461.4
2DLD Change Limit1461622576.75021653.6
3Display Results2572570.1102336.4
 (SQL Overall)1786912577.31324434.7
 
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.