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

139 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
harshly163627(None) 
archly1437352_archly
brashly15427612brashly
earthly13387382earthly
garishly1545692garishly
hardily143310272hardily
hardly135112832har_dly
harsh116418052harsh__
harshen1339282harshen
harsher13310362harsher
hoarsely1444362hoarsely
horsily1338842horsily
marshy14558332marsh_y
rashly123410212ra_shly
apishly1535663apishly
aridly105513703_aridly
arshin9312173_arshin
artily92814713_artily
ashy107717353_a_sh_y
barely114716793bar_ely
barfly14339653bar_fly
basely114412313ba_sely
bashlyk1942463ba_shlyk
bassly114610073ba_ssly
bearishly1774293bearishly
brashy145210593brash_y
charily15310283char_ily
churchly2142973churchly
coarsely1335533coarsely
crassly1276653crassly
darkly145411073dar_kly
darshan1167063darshan
dashy125612383da_sh_y
early85324123ear__ly
earshot10410833earshot
earthily1445613earthily
earthy12399943earth_y
easily9313023ea_sily
fairishly1843573fairishly
falsely1336013falsely
firstly1335643firstly
fleshly16346093fleshly
freshly16286833freshly
gassily1137813gassily
ghastly14354563gha_stly
hackly18298733ha_ckly
haggishly2042913haggishly
hammily1736063hammily
handily143610873handily
hansel95214373hansel_
hansels104011653hansels
haply135915063ha__ply
happily1745763happily
hardhat14411023hardhat
hardship1746043hardship
hardy125622063har__dy
harl75740003har__l_
harls85634503har__ls
harmony1538173harmony
harpy136418213har__py
harry115322953har__ry
harshens1437603harshens
harshest14310193harshest
harslet10315653harslet
hartal9415473hartal_
hartals10313023hartals
hash106936503ha_sh__
hashed136021943ha_shed
hashes125024803ha_shes
hassel95614213hassel_
hassels104311013hassels
hassle93711593ha_ssle
hastily133010663hastily
hasty115718763ha_s_ty
haughty17334643haughty
hawkishly2542753hawkishly
hazelly2254383hazelly
hazily2179063ha_zily
hearsay1335523hears_ay
heartily1436563heartily
herself1337623herself
highly1636823h_ighly
hirsel9138683hirsel_
hirsels10128343hirsels
hirsle9159573hirs_le
hoarily1338973hoar_ily
hornily1338283hornily
horsefly1744873horsefly
horsey125115403hors_ey
horsy116318393hors__y
hostly124210863h_ostly
hurly115819293hur__ly
jadishly2243653jadishly
laithly1335653laithly
largely1136703largely
lastly93310873la_stly
lavishly1744413lavishly
lushly12247343_lushly
marbly134111933mar_bly
marly106925613mar__ly
marsala939583marsala
marsh105320853marsh__
marshal1238973marshal
marshalcy1951773marshalcy
marshall1345483marshall
marshals1337783marshals
marshes123615373marshes
mashy136016503ma_sh_y
oafishly1754093oafishly
ogrishly1544033ogrishly
parsley1247803parsley
partly116315473par_tly
plushly15385383plushly
poshly1437723_poshly
pursily1238213pursily
rakishly1844293rakishly
rarely93513653rar_ely
sashay1238363sa_shay
sassily1038723sassily
sharply15406833shar_ply
sparsely1335123sparsely
tardily11269583tardily
tarsal63315273tarsal_
tarsals72512603tarsals
tartily103511573tartily
tartly96014023tar_tly
tersely1038113tersely
trashily1437323trashily
trashy12509053trash_y
varsity1356673varsity
vastly12508723va_stly
warily122915093war_ily
warmly14228063war_mly
warship1547843warship
warsle93112923wars_le
warstle10328013warstle
washy145911843wa_sh_y
whorishly2143043whorishly
yarely122810303yar_ely

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271396.59320328.7
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.04525364.2
 
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.