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

171 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
hanseled123771(None) 
handseled1444401handseled
hanselled1345471hanselled
aneled74719272_an_eled
angeled93211492_angeled
canceled13279392canceled
channeled1544912channeled
easeled8159842ea_seled
handled124114532han_dled
handselled1543372handselled
hankered16289442hankered
hansel95214372hansel__
hansels104011652hansel_s
hassled11358302ha_ssled
hayseed1435632hayse_ed
hirseled12106252hirseled
houseled1237282houseled
paneled10612572pan_eled
tasseled935582tasseled
tinseled935762tinseled
abseiled1144733_abseiled
aisled74516183_ais_led
anele55628833_an_ele_
aneles64626293_an_eles
angered93013473_angered
angled84219073_an_gled
aniseed839403_anise_ed
ankled114313473_an_kled
annealed936323_annealed
annelid838723_annelid
annexed1535753_annexed
ansated84214003_ansated
answered1235483_answered
anteed75616113_ante_ed
anviled1138943_anviled
axseed1456993_axse_ed
bannered11299323bannered
bantered113313633bantered
barreled1137843barreled
basseted1136743basseted
canaled103615553can_aled
canalled1139573canalled
canceler12238913canceler
cancelled1456743cancelled
cancered132411553cancered
candled113815733can_dled
cankered153010223cankered
cantered113415983cantered
capsuled1334533capsuled
castled104311513ca_stled
chandelled1744273chandelled
channeler1444603channeler
channelled1644143channelled
chiseled1435883chiseled
consoled112911443consoled
counseled1245053counseled
dandered112110963dandered
dandled103313543dan_dled
dangered11248513dangered
dangled104013153dan_gled
dieseled1035523dieseled
enameled1136373enameled
ensiled82611433_ensiled
flanneled1343313flanneled
funneled1254873funneled
gandered112211173gandered
gaveled12399133ga_veled
hackled173312483ha_ckled
haggled13359283ha_ggled
hailed104122743ha__iled
haled95335823ha___led
haltered123112553haltered
hammered16218843hammered
hampered16239923hampered
handed114919983han__ded
handheld1644463handhel_d
handle104219293han_dle_
handler113516163han_dler
handles114020653han_dles
handsel11308723handsel__
handsels12317243handsel_s
hangared1337563hangared
hanged114222393han__ged
hanked144220603han__ked
hankerer15248233hankerer
hanse85722793hans__e_
hanseling1338063hanseling
hanses95022633hans__es
hanted104124313han__ted
hantle94318203han_tle_
hantles104117513han_tles
happened1635653happened
hardened1338613hardened
harkened1637483harkened
harnessed13186193harnessed
harshened1644453harshened
harslet10315653hars_let
hashed136021943ha_s_hed
haslet93222713ha_s_let
hasped125014443ha_s_ped
hassel95614213hassel__
hassels104311013hassel_s
hassle93711593ha_ssle_
hassles103411693ha_ssles
hasted105125283ha_s_ted
hastened12239103hastened
hatcheled1844223hatcheled
hauled104415213ha__uled
havened14429243ha_vened
havered144011453ha_vered
hawkeyed2242403hawkeyed
hayseeds1543283hayse_eds
heeled104018413h__eeled
hindered1339453hindered
hirselled1344683hirselled
hirsled11118113hirs_led
hoarsened1344053hoarsened
hondled123510653hon_dled
honeyed1437773hon_eyed
hoseyed1436953h_oseyed
hosteled1237283hosteled
houselled1346193houselled
hoveled14209293h_oveled
hungered13217053hungered
hunkered16186923hunkered
hustled113210133h_ustled
jangled164111563jan_gled
kantele1138253kantele_
kanteles1238123kanteles
kenneled1334003kenneled
kneeled12328063_kneeled
labeled102510563la_beled
lancelet1049473lancelet
lanceted1137073lanceted
lapeled10258893la_peled
laureled934543laureled
linseed838203linse_ed
manacled1336453manacled
mangled113615253man_gled
mannered11249653mannered
mantelet10613823mantelet
mantled104113393man_tled
marveled1436433marveled
morseled1147193morseled
pandered121812573pandered
panelled1138963panelled
panicled13106783panicled
pantiled113111593pantiled
parceled1338323parceled
rankled123910653ran_kled
ransomed1146933ransomed
rappeled1335003rappeled
rassled83310443ra_ssled
raveled114113633ra_veled
sandaled1039233sandaled
spanceled1443683spanceled
tangled94214633tan_gled
tasselled1044623tasselled
teaseled9186783teaseled
tinselled1044413tinselled
tunneled955233tunneled
unaneled939793unaneled
unsealed91513623_unsealed
unsewed112911023_unsewed
unsexed152410253_unsexed
vesseled1243793vesseled
wandered132110793wandered
wangled123312413wan_gled
warsled112910443wars_led
warstled12286123warstled
weaseled12175133weaseled

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 Limit1461621717.83018666.9
3Display Results1711710.0632714.3
 (SQL Overall)1786911718.04922200.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.