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

367 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
cowpeas143727(None) 
cowpea1337641cowpea_
compas125817062comp_as
compels133210882compels
coopers114019482coopers
copens106119962co_pens
copers104629842co_pers
copes97747102co_pe_s
copperas14308572copperas
coppers133519752coppers
coppras13327832coppras
copras103517152co_pras
corneas94717002corneas
coupes105022522coupe_s
cowers114625532cow_ers
cowpat13312032cowp_at
cowpats1437712cowpats
cowpies143314282cowpies
boheas114013213bo_heas
boppers133911923boppers
boreas85421733bo_reas
bowels114315593bow_els
bowers115523703bow_ers
bowhead1636433bowhead
bowheads1745373bowheads
bowlegs13366823bowlegs
bowlers123715783bowlers
bowless123310313bowless
bowpots1446023bowpots
bowses115718863bowse_s
bowyers15438733bowyers
campers134220293campers
capers105428143c_apers
capes95441923c_ape_s
capias10318353c_apias
cappers134419403cappers
carpels115315463carpels
carpers114521253carpers
carpets113915333carpets
cepes94424463c_epe_s
chapeau1435523chapeau
chapeaus1544993chapeaus
chapels14429153chapels
chapes135421873chape_s
chompers17369593chompers
choppers174110463choppers
choreas124414203choreas
chowders17387543chowders
chowses155611283chowse_s
chuppas1644123chuppas
clepes104214623clepe_s
clowders14357473clowders
clypeal1443513clypeal
clypeus1433243clypeus
coalas87418963co_alas
coalers94419353coalers
coappear1442893coappear
coappears1542953coappears
coapts104614013coap_ts
coatees93816553coatees
coaters93525793coaters
coaxers164311083coaxers
coaxes154715633coaxe_s
cobbers134114753cobbers
cobias104014993co_bias
cobles104622883coble_s
cobras104014193co_bras
cobwebs1631933cobwebs
cocas95926573co__cas
cochleas1545273cochleas
cockers153618333cockers
cocoas104915743co_coas
codas84724243co__das
codders114114453codders
codecs115112933co_decs
codeias103911223codeias
codens94821013co_dens
coders95426983co_ders
codes86247293co_de_s
codgers115113933codgers
coeds85920163co__eds
coffees15329573coffees
coffers154112693coffers
cohead123811123co_head
coheads13289233co_heads
coilers93619903coilers
coiners93620753coiners
cokes115537193co_ke_s
colas75436773co__las
colead94114643co_lead
coleads102911423co_leads
coles76055063co_le_s
coleus86818273co_leus
colies84837053colie_s
collets93517903collets
colters93522443colters
colzas174010513co_lzas
comas95833003co__mas
combers134516623combers
combes125321733combe_s
comers105328083co_mers
comes97246993co_me_s
comets105823583co_mets
commas124814573co_mmas
compass13379563compass
comped135919873compe_d
compeer133811553compeer
compeers143410013compeers
compel124412893compe_l
compend144010303compend
compends15378253compends
compere134616623compere
comperes143217973comperes
compete134716553compete
competes144117243competes
compleat14710153compleat
compos124818803comp_os
compress1439053compress
comps115526053comp__s
compts125216653comp_ts
comtes106222813comte_s
conceal113313013conceal
conceals123111013conceals
conchas144013313conchas
cones76457423co_ne_s
coneys115218423co_neys
confers124120093confers
confess12399903confess
congas94417033co_ngas
congeal104011683congeal
congeals11309853congeals
congees103517923congees
congers104223233congers
conges94928173conge_s
conies84338593conie_s
conkers133721043conkers
conners94023113conners
contes84432913conte_s
contras93015623contras
conveys15308223conveys
cooees85621893co_oees
cooers84324563co_oers
cooeys114914483co_oeys
cookers134619463cookers
cookeys16478503cookeys
coolers93522493coolers
cooped114821603coope_d
cooper104221123coope_r
coopery143910273coopery
coops96229643coop__s
coopts105814583coop_ts
cooters94525723cooters
copal95621783co_p_al
copals105018943co_pals
copay126516313co_p_ay
copays134911273co_pays
cope86847383co_pe__
copeck1636943co_peck
copecks1745873co_pecks
coped105036843co_pe_d
copen94826433co_pe_n
coper95336093co_pe_r
copiers114215963copiers
copies104130303co_pies
copped135221253coppe_d
copper124321893coppe_r
copperah17304903copperah
copperahs18323893copperahs
coppery16409393coppery
coppra12306833coppra_
copra98115463co_pra_
coprah133710603co_prah
coprahs14338153co_prahs
cops86751373co_p__s
copses104922473co_pses
copters113621283copters
copulas113811563copulas
coquets18399893coquets
corbels113813593corbels
corders104520883corders
corers85231073co_rers
cores76361853co_re_s
corkers134118853corkers
cormels113813373cormels
cornea84018923cornea_
corneal94414503corneal
cornels94716663cornels
corners94723313corners
cornets94820573cornets
coronas93916913coronas
corps95927043corp__s
corpses113913803corpses
corpus106015293corp_us
corses84433463corse_s
corsets94819803corsets
corvees124613793corvees
corves115122523corve_s
corvets124715023corvets
coryzas2134803coryzas
cosecs105015213co_secs
coses76949493co_se_s
cosets85824403co_sets
coseys115215813co_seys
coshers123618183coshers
coshes115022783coshe_s
cosies84932153cosie_s
cossets95014283cossets
costers94128333costers
coteau8311083co_teau
cotes76347843co_te_s
cottas84615573co_ttas
cotters94323443cotters
cotypes1437943cotype_s
coulees9315513coulees
coupe96023483coupe__
couped115019313coupe_d
couplers123311323couplers
couples115317053couples
couplets12389873couplets
coupons112710563coupons
coups95522473coup__s
couteau938833couteau
couters93827303couters
covens114919263co_vens
covers114627963co_vers
coves105539173co_ve_s
covets114819643co_vets
coveys145413503co_veys
cowages13310943cowages
cowards1339613cowards
cowbell1445223cowbell
cowbells1544993cowbells
cowboys1735253cowboys
cowed115637853cow_e_d
cower104531773cow_e_r
cowflap1742503cowflap
cowflaps1842293cowflaps
cowherb1735103cowherb
cowherbs1833543cowherbs
cowherd1636953cowherd
cowherds1735423cowherds
cowier113616163cowie_r
cowiest123614673cowiest
cowled125218393cowle_d
cowls106922213cow__ls
cowman13910373cow_man
cowmen13810923cowme_n
cowpie133511513cowp_ie
cowplop1643363cowplop
cowplops1743173cowplops
cowpoke1835103cowpoke
cowpokes1944573cowpokes
cowpox2035003cowp_ox
cowpoxes2244513cowpoxes
cowries124218013cowries
cows97046643cow___s
cowsheds1734743cowsheds
coxes145430863co_xe_s
coxless1637743coxless
coyness1277323coyness
coypous14248813coypous
coypus13389303coyp_us
cozens176314923co_zens
cozes166033243co_ze_s
cozeys204610913co_zeys
cozies174521413cozie_s
cozzes164510893cozze_s
crapes104727693crape_s
crepes105419343crepe_s
cripes105120873cripe_s
croppers143311483croppers
croupes114613103croupe_s
crowders14398813crowders
crowers124614903crow_ers
crowners133710753crowners
crownets13407673crownets
cupels10310203c_upels
cuppas12458593c_uppas
cuppers133712213cuppers
dopas85019063do_p_as
dopers95522483do_pers
dopes84935043do_pe_s
dorpers104113173dorpers
dowels104813343dow_els
dowers104523293dow_ers
downers113912773downers
dowsers115013533dowsers
dowses105718303dowse_s
foveas1238623fo_veas
fowlers133411203fowlers
gawpers13448313gawpers
gospels1035593gospels
hoopers123616483hoopers
hooplas1239203hooplas
hopers114222973ho_pers
hopes105835643ho_pe_s
hoppers143115143hoppers
howes114730263how_e_s
howlers133312353howlers
howlets13329223howlets
kopeks1134603ko_peks
koppas14407603ko_ppas
loopers93914033loopers
lopers84424143lo_pers
lopes76437343lo_pe_s
loppers113014103loppers
loupes84918053loupe_s
lowers94624923low_ers
lowes85732463low_e_s
lowness1037813lowness
mopeds11499663mo_peds
mopers104220373mo_pers
mopes95134983mo_pe_s
moppers133412463moppers
moppets13307163moppets
mowers113219403mow_ers
nonpeak1345473nonpeak
nowness1037033nowness
opens76118553_o_pens
operas8312453_o_peras
opes65942613_o_pe_s
owes75137103_ow_e_s
owlets93110393_owlets
owners94210703_owners
peas65755063___peas
popes95933813po_pe_s
poppas93710713po_ppas
poppers103414863poppers
poppets10338853poppets
powders134111553powders
powers113822323pow_ers
powters124015663powters
rompers113412243rompers
ropers84325903ro_pers
ropes75940063ro_pe_s
rowels94515453row_els
rowens94515303row_ens
rowers94924573row_ers
scoopers124210193scoopers
scopes104719593sco_pe_s
scowders14276233scowders
scowlers13257373scowlers
soapers93715923soapers
sowens93613153sow_ens
sowers94923443sow_ers
toeas55726423to__eas
topees85519703to_pees
topers85025323to_pers
topes76941763to_pe_s
toppers113914603toppers
toupees938513toupees
towels94314643tow_els
towers94423673tow_ers
towhead1435223towhead
towheads1544813towheads
towhees13277793towhees
towies93521193towie_s
townees10269783townees
vowels124410483vow_els
vowers124317183vow_ers
vowless13246603vowless
wowsers13488763wowsers
yawpers15346853yawpers
yowes114926373yow_e_s
yowies123913733yowie_s
yowlers13328923yowlers
zoeas145815613zo__eas

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.406440125.6
2DLD Change Limit1340273676.17321711.8
3Display Results3673670.1402621.4
 (SQL Overall)1786913676.71926594.9
 
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.