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

273 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
countess10371005(None) 
counters103320191counters
countless1146371countless
chunters133910902chunters
cointers103616412cointers
confess12399902co_nfess
contes84432912co_nte_s
contessa1044582co_ntessa
contest93523232co_ntest
contests103413382co_ntests
coulters103614312coulters
counsels1037572counsels
counted103815802counte_d
counter94220152counte_r
countesses1248842countesses
counties10316282counties
counts84618272count__s
courters103015372courters
courtesy1364972courtesy
couters93827302cou_ters
coyness1277322coyn_ess
mounters103712502mounters
nounless837252nounless
bluntest1036553bluntest
bluntness1144343bluntness
boonless10328353boonless
bouncers12309353bouncers
bounces113813683bounce_s
bounders114314113bounders
boundless1235183boundless
boundness1235943boundness
bounteous1144303bounteous
bounties10311403bounties
bunters94717123_bunters
canters94827733c_anters
centers94420603c_enters
centeses1079443c_enteses
centesis1058143c_entesis
chanters134016743chanters
chanteys16387493chanteys
chaunters1455823chaunters
chinless1337493chinless
chintses1337113chintses
chunnels13304553chunnels
chunter123911483chunte_r
chutes114615773chu_te_s
chutnees1343963chutnees
chutneys1642323chutneys
cloudless1243153cloudless
clouters10399803clou_ters
clueless1035883clueless
clunkers14327553clunkers
clusters102912403clusters
clutters103210353clutters
coalless1038193coalless
coasters104317333coasters
coatees93816553co_atees
coaters93525793co_aters
coatless1039693coatless
coattest1038863coattest
coattests1143463coattests
codeless112010113codeless
cognates11311583cognate_s
cognises11610043cognises
cohostess1443453cohostess
cohunes1249713cohun_e_s
coiners93620753coin_ers
coinfers13349503coinfers
cointer93616723cointe_r
coldness1137953coldness
colters93522443co_lters
comates114123643comate_s
compress1439053compress
comtes106222813co_mte_s
concuss1138063co_ncuss
cones76457423co_n_e_s
coneys115218423co_n_eys
confers124120093co_nfers
congees103517923co_ngees
congers104223233co_ngers
conges94928173co_nge_s
congest104618773co_ngest
congests113510383co_ngests
congress1138073congress
conies84338593co_nie_s
conkers133721043co_nkers
conners94023113co_nners
connotes10311453connote_s
conte76633203co_nte__
contemn1137803co_ntemn
contemns1237403co_ntemns
contend103511893co_ntend
contends112810573co_ntends
content94326153co_ntent
contents104018213co_ntents
contessas1145023co_ntessas
context163913433co_ntext
contexts17378653co_ntexts
contos84923233co_nt_os
contras93015623co_ntras
contuse9311413co_ntuse
contuses10413453co_ntuses
conveys15308223co_nveys
cookless14258633cookless
coolness1037743coolness
coonties10513803coonties
cooters94525723co_oters
copters113621283co_pters
cordless11299963cordless
coreless103013833coreless
corneas94717003corn_eas
cornels94716663corn_els
corners94723313corn_ers
cornets94820573corn_ets
corniest102117303corniest
corniness112611183corniness
cornuses10310033cornuses
cosiness103214283cosiness
costers94128333co_sters
costless10310003costless
cotes76347843co__te_s
cotters94323443co_tters
couchers153513863couchers
couches144020473couche_s
coughers14399963coughers
couldest1148353couldest
coulees9315513cou_lees
coulter94115603coulte_r
councils1246973councils
counsel948543counse_l
count74932053count___
countered12313003countered
counterspy1744663counterspy
countersue1247743countersue
countersues1348533countersues
countian1048123countian
countians1147333countians
counting113115273counting
countlessly1653123countlessly
countries11313613countries
country12388043count_ry
county114313323count__y
coupes105022523cou_pe_s
couplers123311323couplers
couples115317053couple_s
couplets12389873couplets
courantes1148883courante_s
couriers103213173couriers
coursers104412303coursers
courses94218893course_s
courted103514923courte_d
courteous1145813courteous
courter94516483courte_r
courtesan1144173courtesan
courtesans1244253courtesans
courtesies1246453courtesies
courtiers1146693courtiers
courts84216173court__s
couteau938833cou_teau
couter84930223cou_te_r
couthest13312083couthest
couths115715413cou_t_hs
coveters132411083coveters
coxless1637743co_xless
coyotes12410703coyote_s
coziness19319823coziness
croutes94815653crou_te_s
crownless1443423crownless
crustless1155403crustless
cunners93913473c_unners
cunts76125123c_unt__s
curtest9713963c_urtest
curtesy1265833c_urtesy
curtness1037263c_urtness
cutes79438323c_u_te_s
cutest85820143c_u_test
cutesy114810733c_u_tesy
cuteys11569983c_u_teys
cutters94218963c_utters
daunters9329853daunters
dauntless1033663dauntless
doubters11257393doubters
doubtless1243313doubtless
dourness947683dourness
downless1236363downless
dunness8298983_dunness
encounters1244553encounters
foulness11236653foulness
founders123911673founders
founts94313383fount__s
gauntest936603gauntest
gauntness1044203gauntness
giantess933893giantess
grunters9359033grunters
gunless8299633_gunless
haunters11329543haunters
hornless1137363hornless
hostess103210243ho_stess
hotness1038613hotn_ess
hounders123111713hounders
hunters103915733_hunters
huntress1144833_huntress
jointers15289323jointers
jointless1634323jointless
jointress1643053jointress
jounces16369853jounce_s
jousters153210423jousters
lornness836493lornness
lostness837683lostness
loudness937013loudness
loungers9449003loungers
lounges84811353lounge_s
lowness1037813lown_ess
montes84226933mo_nte_s
moonless10278043moonless
mootness1036753mootness
moulters103510783moulters
mounted103611533mounte_d
mounter93713173mounte_r
mounts84115073mount__s
nowness1037033nown_ess
ounces83617773_ounce_s
ousters74122793_ousters
outers64230173_ou_ters
poetess938933po_etess
pointers103013723pointers
pointes93216753pointe_s
pointless1135703pointless
pontes83627853po_nte_s
poulters103911053poulters
pouncers12349203pouncers
pounces114113893pounce_s
pounders113113283pounders
pouters94221873pou_ters
punters93617043_punters
recounters1246213recounters
roundels9217753roundels
rounders92613693rounders
roundest9310473roundest
roundness1047013roundness
rousters84315683rousters
routers74822873rou_ters
routes66129313rou_te_s
runless72810423_runless
saunters82911753saunters
scouters103411323scou_ters
shunters113210753shunters
softness1136433softness
sonless72612613so_nless
soulless8218763soulless
sounders93214113sounders
soundest9510973soundest
soundless1035533soundless
soundness1036963soundness
soupless10268463soupless
sourness839543sourness
souters74422603sou_ters
stoutness945863stoutness
sunless73013693_sunless
taunters8259273taunters
tautness8217183tautness
touters74018353tou_ters
townless1135653townless
unless62413073__unless
vaunters11327753vaunters
viscountess1662383viscountess
woeness1020211543woen_ess
wornness1136363wornness
woundless1334033woundless
youngers12336933youngers
youngest1244903youngest
youngness1343373youngness
younkers15295763younkers

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.1561145455.1
2DLD Change Limit1461622737.42319690.4
3Display Results2732730.1102481.8
 (SQL Overall)1786912737.68923239.8
 
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.