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

233 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
channels1338849(None) 
cannels93413361c_annels
chancels15439081chancels
channel123910481channel_
charnels13328171charnels
chunnels13304551chunnels
cancels114113312c_ancels
cannel84216402c_annel_
canners93822662c_anners
chaines124518732chaine_s
chancel144011772chancel_
chancers154313482chancers
chances145218092chance_s
changers144313192changers
changes134517582change_s
channeled1544912channeled
channeler1444602channeler
channelers1543852channelers
chanters134016722chanters
chanteys16387492chanteys
chapels14429152cha_pels
charnel124010052charnel_
chattels13286792chattels
chunnel12395302chunnel_
flannels1134842flannels
hansels104011652_hansels
rechannels1543182rechannels
scrannels1143512scrannels
angels74416173__angels
annals66415923__annals
anneals7449943__anneals
annuls64711733__annuls
archangels1643283archangels
banners94018713_banners
bannets94013843_bannets
branners104010923branners
camels105217083c_a_mels
canals84421663c_a_nals
cancel105316683c_ancel_
cancers114018583c_ancers
candela1089743c_andela
candelas1139533c_andelas
candles104422343c_andles
caners84629193c_a_ners
canes75350373c_a_ne_s
canfuls1248423c_anfuls
canines93724033c_anine_s
cankers134418753c_ankers
cannas84518403c_ann_as
canned95022063c_anne_d
cannelon1045123c_annelon
cannelons1145213c_annelons
canner84625983c_anne_r
cannery123610003c_annery
cannily1239263c_annily
cannoli937263c_annoli
cannolis1037863c_annolis
cannons94412883c_annons
cannula937433c_annula
cannulas1037583c_annulas
canoers94318373c_anoers
canoes84725883c_anoe_s
canoness1039393c_anoness
cantals93919573c_antals
canters94827723c_anters
cantles94721413c_antles
carcels114516063c_arcels
carnets93918403c_arnets
carneys124310543c_arneys
carpels115315463c_arpels
carrels95117303c_arrels
cartels94618123c_artels
carvels124914593c_arvels
chaconnes1644003chaconne_s
chadless1436403chadless
chaebols1544723chaebols
chafers154512723cha_fers
chafes145017913cha_fe_s
chaffers19377993chaffers
chaine115119223chaine__
chained133812693chaine_d
chains114819703chain__s
chaises124317493chaise_s
chalehs15268803cha_lehs
chalets122813473cha_lets
chalones13312173chalone_s
chambers173410613chambers
chamfers18409213chamfers
champers173311613champers
chance134617093chance__
chanced154113213chance_d
chancer144215633chance_r
chancery18366653chancery
chancily1845243chancily
chanciness1745123chanciness
chancres15429363chancres
chandelle1545223chandelle
chandelles1645333chandelles
chandler14358373chandler
chandlers15387673chandlers
change124116753change__
changed144214143change_d
changeless1643873changeless
changer134215543change_r
changeup1642683changeup
changeups1742183changeups
changs125215373cha_n_gs
channeling1645203channeling
channelize2453263channelize
channelizes2552993channelizes
channelled1644143channelled
chanoyus1643913chanoyus
chansons1337473chansons
chanted134015953chante_d
chanter123919733chante_r
chanteuse1443473chanteuse
chantey154112543chante_y
chanties132615803chanties
chantors133710253chantors
chants115020393cha_n_ts
chaoses124715113chaose_s
chapel134911373cha_pel_
chapes135421873cha_pe_s
chaplets1556883chaplets
chapters154012113chapters
chares115631803cha_re_s
chargers144011313chargers
charges134615983charge_s
chariness14310063chariness
charleys1695633charleys
charmers154211323charmers
charters134115563charters
chasers123714893cha_sers
chases115128233cha_se_s
chasses124017503chasse_s
chastely1635813chastely
chastens13429183chastens
chattel12388893chattel_
chatters134213933chatters
chaufers16347283chaufers
chaunters1455813chaunters
chaunts1267083chaun_ts
chawers154412033cha_wers
chazzens21253943chazzens
cheapness1643743cheapness
chicness1535593chicness
chiels115115933ch__iels
chimneys1883643chimneys
chines115029173ch_ine_s
chinless1337493chinless
chinned134810493chinne_d
chinones13510473chinone_s
chisels12219103ch_isels
chunters133910893chunters
churners13316883churners
chutnees1343963chutnees
chutneys1642323chutneys
clangers114312343clangers
cleanness1144973cleanness
coannex1635503coanne_x
coannexes1843643coannexes
colonels104210453colonels
conners94023113c_onners
cornels94716663c_ornels
coronels104012143coronels
counsels1037573counsels
cracknels1743433cracknels
cranes84330753cra_ne_s
crankles143510153crankles
crannies10313013crannies
crannogs1143783crannogs
crenels93711013c_renels
cunners93913463c_unners
cyanines132710543cyanine_s
darnels83710433_darnels
evangels1243733evangels
fanners103914653_fanners
fennels10387903_fennels
flannel1035423flannel_
funnels10348173_funnels
gannets83811443_gannets
grapnels1134393grapnels
gunnels8358563_gunnels
hallels103310133_hallels
hances115621283_hance_s
handers114224333_handers
handles114020653_handles
handsels12317243_handsels
hangers113120813_hangers
hankers144218133_hankers
hansel95214373_hansel_
hanses95022633_hanse_s
hantles104117513_hantles
harness102413933_harness
hassels104311013_hassels
hazels185710083_ha_zels
joannes1436243joanne_s
johannes1842943johanne_s
kennels11387193_kennels
lanners73618323_lanners
leanness837373leanness
mangels103614493_mangels
manners93417833_manners
mantels94515043_mantels
meanness1037183meanness
mischannels1852193mischannels
panels84716523_pa_nels
panners93621273_panners
pannes85522853_panne_s
planners10399933planners
rechannel1444323rechannel_
ronnels7318613_ronnels
runnels7329153_runnels
scanners10379703scanners
scrannel1044033scrannel_
shannies113411253shannies
shanteys14395503shanteys
shinneys14275093shinneys
shunners11317743shunners
spancels1245273spancels
spaniels1045963spaniels
spanners103710773spanners
tanners74018393_tanners
thanes94918983tha_ne_s
thankers15297833thankers
thinners11327743thinners
thinness11277153thinness
trunnels844513trunnels
tunnels7328723_tunnels
vanners103612843_vanners
wanness102610683_wanness
whangees15275063whangees
whatness1435093whatness

Search took 10 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.186960704.3
2DLD Change Limit1461622338.86016496.8
3Display Results2332330.0962427.1
 (SQL Overall)1786912339.14219546.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.