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

196 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
coarsest103916(None) 
hoarsest1137131hoarsest
carses85233652c_arses_
chariest13315502chariest
coaliest10316222coaliest
coarse84813902coarse__
coarsely1335532coarsely
coarsen93210322coarse_n
coarsens10348122coarsens
coarser93211202coarse_r
coassist10298802coassist
coattest1038862coattest
corses84433462co_rses_
corset85636222co_rse_t
corsets94819802co_rsets
courses94218892courses_
crassest103411522crassest
hoariest11312882hoariest
sparsest1048812sparsest
arrest63722633__arrest
arses55733873__arses_
barest85327693_bar_est
basest84720493_ba_sest
bourses94014303bourses_
cagiest102916433c_agiest
cakiest133215663c_akiest
calmest11312343c_almest
cares77369183c_ar_es_
caress85720263c_ar_ess
caret75360563c_ar_e_t
carets85330773c_ar_ets
caries85147623c_aries_
carles85435083c_arles_
carless95118493c_arless
carnet84732873c_arne_t
carnets93918403c_arnets
carpet104530093c_arpe_t
carpets113915333c_arpets
carse74934333c_arse__
cartes86239473c_artes_
carves115128453c_arves_
cases75048383c_a_ses_
causes88026473c_auses_
ceases84427073cea_ses_
chaises124317493chaises_
chaoses124715123chaoses_
charases131312763charases_
chares115631803char_es_
charges134615983charges_
charriest1438253charriest
chartist131112133chartist
chases115128233cha_ses_
chasses124017503chasses_
chastest1349703chastest
chirkest1735383chirkest
claret84026573clar_e_t
clarets94111103clar_ets
claries93422203claries_
claroes93113733claroes_
classes94717943classes_
classiest11309543classiest
classist104010383classist
clauses93813323clauses_
clayiest1337913clayiest
clearest1038653clear_est
closest94312533c_losest
coaches144018693coaches_
coagent10313983coa_gent
coalless1038193coalless
coarsened1245143coarsened
coarseness1246173coarseness
coassists11275763coassists
coast75236273coa___st
coasts85719143coa_sts_
coatees93816553coatees_
coatless1039693coatless
coattests1143463coattests
coaxes154715633coa_xes_
cobbiest14118523cobbiest
cockiest163013293cockiest
coerces11311943coerces_
coerect11913353coer_ect
coldest102514763co_ldest
comfiest1539133comfiest
concisest1348253concisest
congest104618773co_ngest
conquest1939553conquest
consent93723113co_nsent
consist9316033co_nsist
contest93523233co_ntest
coolest9318643co_olest
coparent12412253copar_ent
copresent1349923copresent
copses104922473co_pses_
cores76361853co_r_es_
corkiest143114793corkiest
cornet84436733co_rne_t
cornets94820573co_rnets
corniest102117303corniest
corpses113913803corpses_
correct11513983co_rrect
corries94026793corries_
corse75036183co_rse__
corselet10414573co_rselet
corslet9318063co_rslet
corslets1038273co_rslets
corves115122523co_rves_
corvet114626933co_rve_t
corvets124715023co_rvets
coses76949493co__ses_
coset75748843co__se_t
cosets85824403co__sets
cosiest93819853co_siest
cosset84125863co_sse_t
cossets95014283co_ssets
couldest1148353couldest
course85117783course__
coursed104113603course_d
courser94114803course_r
coursers104412303coursers
courtesy1364973courtesy
couthest13312083couthest
covaries13413253covaries_
cowiest123614673co_wiest
cowries124218013cowries_
coyest11316053co__yest
coziest184014353co_ziest
crankest1438143crankest
crases85532313cra_ses_
craziest19319923craziest
crest74632693c__r_est
croakiest15167173croakiest
crossest1012012123crossest
curses85328273c_urses_
curtest9713963c_urtest
czarist18710223czar_ist
darkest122512623_darkest
dearest83618673dear_est
dourest8312943dour_est
dwarfest1543473dwarfest
earnest7318733_earnest
falsest10310013_falsest
foamiest13289853foamiest
forest94926743fo_r_est
glariest92012523glariest
goriest82218743go_riest
gorses74723293go_rses_
gorsiest92511133go_rsiest
hardest113118413_hardest
harshest14310193_harshest
harvest132112753_harvest
hearses104414533hearses_
hoarse94411323hoarse__
hoarsely1444363hoarsely
hoarsen10367993hoarse_n
hoarsens11306023hoarsens
hoarser10388393hoarse_r
horses94729343ho_rses_
horsiest112513263ho_rsiest
largest83715103_largest
leariest83117843leariest
loamiest102310203loamiest
loosest75811563lo_osest
marses84827113_marses_
mooriest102812723mooriest
nearest73415843near_est
oakiest112913923_oakiest
oarless73913373_oarless
oases55330983_oa_ses_
parses85534703_parses_
peartest10311303peartest
poorest9312773poor_est
rarest65725483_rar_est
rearrest8311603rearrest
scarcest12169173scarcest
scariest101615943scariest
searest73322023sear_est
sharpest1339143sharpest
smartest10310183smartest
soapiest102412843soapiest
sorest65028003so_r_est
sorriest8413883sorriest
sourest7515713sour_est
sparest94616423spar_est
starkest1239723starkest
tartest72517533_tartest
teariest82417263teariest
tersest71713993_tersest
torses64727953to_rses_
wariest105122503_wariest
warmest123113033_warmest
weariest112914793weariest
worses95522953wo_rses_
worset96726583wo_rse_t
worsets105512843wo_rsets
yarest95018913_yar_est

Search took 9 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 Limit1461621967.80018738.7
3Display Results1961960.0762578.9
 (SQL Overall)1786911968.03222247.4
 
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.