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 “chores” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

198 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
chores11482802(None) 
chares115631801chares
chokes154917381chokes
chords125214631chords
chore105126761chore_
chorea115216091chorea
choreas124414201choreas
chored125321881chored
chorus115014771chorus
choses115825131choses
cores76361851c_ores
crores86121161crores
shores94830411shores
whores125617101whores
adores74420722adores
ahorse9311512ahorse
bores76448252_bores
cadres94017932cadres
cares77369182c_ares
ceorls848162ceorls
ceres75540012c_eres
chafes145017912chafes
chaoses124715122chaoses
chapes135421872chapes
charas114223612charas
chards125119732chards
chare105231982chare_
chared125423692chared
charges134615982charges
charks155219702charks
charms135218842charms
charrs115219192charrs
chars105936642char_s
charts115823092charts
chases115128232chases
cheers114518912cheers
cherts115617232cherts
chevres15379792chevres
chides124620472chides
chiles115425302chiles
chimes134922572chimes
chines115029172chines
chirks155414842chirks
chirms135113982chirms
chiros114617772chiros
chirps135414002chirps
chirres123812252chirres
chirrs114514982chirrs
chirus114615692chirus
chives144317592chives
chocks174815312chocks
choices142010612choices
choired13349342choired
choirs114911882choirs
choke145118022choke_
choked164914792choked
choker154314372choker
chokers164311522chokers
chokey184811712chokey
cholas114818002cholas
choler113717152choler
cholers124215202cholers
cholos114716852cholos
chomps155112222chomps
chooks155312792chooks
choose115116142choose
chooses125717432chooses
chops125019872cho_ps
choral115118492choral
chorales133712882chorales
chorals124614112chorals
chord115917262chor_d
chorded144710552chorded
choreal124412222choreal
choregi1344562choregi
choregus1484212choregus
choreic1438702choreic
choric133515902choric
chorines132917252chorines
chorten122811302chorten
chortens13308792chortens
chortles133611322chortles
choruses1339982choruses
chose105925402chose_
chosen116014132chosen
chotts113610992chotts
chouse116017562chouse
chouses125117812chouses
chowed154914652chowed
chows135618202cho_ws
chowse144711752chowse
chowses155611282chowses
chromes142914932chromes
churls115411072churls
churns114910232churns
churrs115111512churrs
chutes114615772chutes
chyles144813282chyles
chymes165912152chymes
cires74932912c_ires
clones84526562clones
closes85425592closes
cloves114918822cloves
clozes174915562clozes
codes86247292c_odes
coheres122917692coheres
cohorts123411102cohorts
cokes115537192c_okes
coles76055062c_oles
comes97246992c_omes
cones76457422c_ones
cooees85621892cooees
cooers84324562cooers
copes97747102c_opes
cords86030622c_ords
core67263112c_ore_
cored85044222c_ored
corer75538872c_orer
corers85231072c_orers
corks116028272c_orks
corms95626222c_orms
corns76034762c_orns
corps95927042c_orps
cors66656442c_or_s
corse75036182c_orse
corses84433462c_orses
corves115122522c_orves
coses76949492c_oses
cotes76347842c_otes
coves105539172c_oves
coxes145430862c_oxes
cozes166033242c_ozes
crones84729242crones
crore74922872crore_
crozes174417662crozes
cures75645432c_ures
cypres1338522cypres
dholes104914792dholes
echoers12459692echoers
echoes114715522echo_es
fores85847102_fores
gores65740372_gores
hares86255542_hares
heres86245902_heres
hires86134342_hires
hoers85724922_hoers
hoes75755732_ho_es
hokes126231642_hokes
holes84748652_holes
homes106938822_homes
hones88144492_hones
hopes105835642_hopes
horas86333102_horas
hordes104921632_hordes
horns86125332_horns
horse86132652_horse
horses94729352_horses
hoses85443182_hoses
howes114730262_howes
ichors11310422ichor_s
lores55045402_lores
mores76249642_mores
ochres113510832och_res
ores46056682__ores
phones114121212phones
phoresy1534652phoresy
pores75849032_pores
schorls1248352schorls
scores84725922scores
shares95236412shares
shires95225572shires
shoers94518332shoers
shoes85429662sho_es
shore85432652shore_
shored105723652shored
shorls94516202shorls
shorts95321742shorts
shotes95321912shotes
shoves124919422shoves
snores64324322snores
sores55454282_sores
spores84726612spores
stores65533662stores
theres96525472theres
tholes94919782tholes
thorns95314102thorns
thorpes125010352thorpes
thorps113610892thorps
throes97518672throes
tores55352672_tores
tsores65113662tsores
wheres125917442wheres
wholes124616772wholes
whore116018042whore_
whored135512122whored
whorls124410162whorls
whorts125111432whorts
yores85031322_yores

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511982.43633887.9
3Display Results1981980.0633142.9
 (SQL Overall)1786911982.84262875.1
 
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.