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

101 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
coarsely133553(None) 
hoarsely1444361hoarsely
coarse84813902coarse__
coarsen93210322coarse_n
coarsens10348122coarsens
coarser93211202coarse_r
coarsest1039162coarsest
sparsely1335122sparsely
aversely1444853aversely
barely114716793_bar_ely
basely114412313_ba_sely
carcel105018673c_arcel_
carcels114516063c_arcels
carney115315703c_arne_y
carpel105418473c_arpel_
carpels115315463c_arpels
carrel84718633c_arrel_
carrell94610473c_arrell
carrels95117303c_arrels
carse74934333c_arse__
carses85233653c_arse_s
cartel85022533c_artel_
cartels94618123c_artels
carvel114817573c_arvel_
carvels124914593c_arvels
casefy1436273c_a_sefy
causey113513273c_ause_y
charily15310283char_ily
charley15118273charle_y
charnel124010053charnel_
charnels13328173charnels
chastely1635813chastely
classily1336623classily
closely1237053c_losely
coaly105521593coa___ly
coarsened1245143coarsened
comely134213733co__mely
comradely1783483comradely
concisely1645323concisely
conversely1844903conversely
corbel103715973co_rbel_
corbels113813593co_rbels
cormel103815603co_rmel_
cormels113813373co_rmels
cornel84020053co_rnel_
cornels94716663co_rnels
cornily12410853co_rnily
corse75036183co_rse__
corselet10414573co_rselet
corses84433463co_rse_s
corset85636223co_rse_t
corsetry1365573co_rsetry
corsets94819803co_rsets
corslet9318063co_rslet
cosey106226713co__se_y
cosily113613853co__sily
costly114012333co__stly
counsel948543counsel_
counsels1037573counsels
course85117783course__
coursed104113603course_d
courser94114803course_r
coursers104412303coursers
courses94218893course_s
courtesy1364973courtesy
courtly1256923cour_tly
cowardly1744093cowar_dly
crassly1276653cra_ssly
crousely1346563crousely
cursedly1444173c_ursedly
cymosely1842973cymosely
dorsel75315503do_rsel_
dorsels84412573do_rsels
falsely1336013_falsely
harshly1636273_harshly
hoarily1338973hoar_ily
hoarse94411323hoarse__
hoarsen10367993hoarse_n
hoarsens11306023hoarsens
hoarser10388393hoarse_r
hoarsest1137133hoarsest
horsefly1744873ho_rsefly
horsey125115403ho_rse_y
horsily1338843ho_rsily
jocosely2042763jocosely
largely1136703_largely
loosely1036713lo_osely
morosely1345713morosely
morsel85815893mo_rsel_
morsels94112653mo_rsels
obesely1245113_obesely
ourself1057453_ourself
parsley1247793_parsley
rarely93513653_rar_ely
scarcely1534313scarcely
sorely94618013so_r_ely
sparely123410673spar_ely
tersely1038103_tersely
weasely13317853wea_sely
yarely122810303_yar_ely
yourself1442653yourself

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621016.78321548.3
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.98525582.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.