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

177 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
ashcan113584(None) 
ashcans1235181ashcans
ashman1148381ashman
ashcake1663372ashcake
ashen87818672ash_en
ashlar9338192ashlar
ashmen1168172ashmen
ashram1139052ashram
scan65530452_s_can
abaca95118043abaca_
abacas104414723abacas
adman84517903a_dman
afghan1333873afghan
agha87417303agh_a_
aghas97014873agh_as
aha611246643a_h_a_
ahead96817053a_head
aidman92410623aidman
airman82414223airman
ajowan1634893ajowan
alan46844083a__lan
ameban1039093ameban
ancon75718233a_ncon
anuran64313243anuran
apian75018333a_pian
apical10913903apical
arcana8912583a_rcana
arcane81216743a_rcane
archean1269123archean
archon11311753archon
areca75618633areca_
arecas84817443arecas
arhat8327093arh_at
arshin9312173arsh_in
asana5315483as__ana
asanas6514113asanas
ascend9429733as_cend
ascent84519653as_cent
asci66519143as_c_i
ascot76522513as_cot
ascus75013583as_cus
asea46327183as_ea_
ash67944603ash___
ashcakes1753733ashcakes
ashed97829773ash_ed
ashes86230613ash_es
ashfall1343943ashfall
ashier94714833ashier
ashing107824093ashing
ashlars10297063ashlars
ashler9459973ashler
ashore9414613ashore
ashplant1345413ashplant
ashrams1236653ashrams
ashtray13805553ashtray
ashy107717353ash__y
askant10412713as_kant
aslant6317753as_lant
asocial998653asocial
aspen75216093as_pen
assai5711543as_sai
assay8710283as_say
assign736783assign
astern64815813astern
asthma11126563asthma_
asthmas12117363asthmas
astral66919283astral
astray95615543astray
aswoon947013aswoon
asyla839333asyla_
ataman81013063ataman
atman75520143a_tman
avian84616053a_vian
axeman1538103axeman
axman144813183a_xman
azan136521783a__zan
barchan1469133barchan
baseman1138553baseman
bashaw14349303bash_aw
bushman1455693bushman
can57760143___can
cancan10314103cancan
cashaw14439793cash_aw
darshan1167063darsh_an
dasheen1136393dasheen
dishpan13105523dishpan
escar74011993es_car
eschar1136533eschar
fashion1337843fashion
gascon9339723gas_con
gasman92911743gas_man
glucan936183glucan
glycan1234903glycan
hwan105716893__hwan
kasha124710723kash_a_
kashas133311903kash_as
khan115819143_kh_an
lascar868573las_car
lashkar1443703lashkar
lochan1139093lochan
mascon103612743mas_con
oilcan837793oilcan
paphian1437453paphian
pascal10812373pas_cal
paschal14157243paschal
pasha105417183pash_a_
pashas115117063pash_as
pecan91919033_pecan
pechan13511543pechan
pshaw13447513psh_aw
rascal8511123ras_cal
sampan102511893sampan
saran53730303_saran
sashay1238363sash_ay
scab85926713_s_cab
scad75725773_s_cad
scag76626893_s_cag
scam85932353_s_cam
scans74625103_s_cans
scant79735073_s_cant
scar66434203_s_car
scat65848373_s_cat
schav1338313_schav
secant84023293_secant
sedan65620423_sedan
sewan85921293_sewan
sha69837783_sh_a_
shack145321753_shack
shad86230913_sh_ad
shag86430563_sh_ag
shah105627783_sh_ah
sham96436363_sh_am
shaman113314283_shaman
shank125422193_sh_ank
sharn84823703_sharn
shat76456603_sh_at
shaw108132553_sh_aw
shawn116417613_shawn
shay107133343_sh_ay
shea76031573_shea_
sheaf115424123_sheaf
sheal84927703_sheal
shear85424833_shear
sheas86331793_sheas
sheen85023313_sheen
shewn115715703_shewn
shin75634313_sh_in
shoal83920273_shoal
shoat85633953_shoat
shoon84022013_shoon
shoran94016043_shoran
shorn85722183_shorn
shown115216483_shown
shrank13359123_shrank
shuln84713113_shuln
shun75122773_sh_un
shwa106014963_shwa_
shwas116415103_shwas
siccan1037593siccan
skean94415623_skean
soca66330053_soca_
socas74026183_socas
socman1039813_socman
solan55328153_solan
soman75024903_soman
span65234663_s_pan
spean74620513_spean
swan76631313_s_wan
than76128773_th_an
toucan838193toucan
trashman1345813trashman
uhlan849113_uhlan
washday1743383washday
washrag1444043washrag
wiccan1335033wiccan
yashmac1742563yashmac
yashmak1942743yashmak

Search took 6 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 Filter1786911127160.766233278.1
2DLD Change Limit1127161775.14021929.2
3Display Results1771770.0632809.5
 (SQL Overall)1786911775.96929936.5
 
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.