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

186 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
unheard113694(None) 
heard95222752__heard
outheard1288542outheard
reheard11309022reheard
unbear889162unbear_
unbeared111611652unbeared
unbears998042unbears
undead82711902undea_d
unfeared121511012unfeared
unguard955092unguard
unhand10410382unh_and
unhealed121511072unhealed
unheated121514552unheated
unitard838002unitard
unlead73312372unlea_d
unlearn735952unlearn
unread73412672unrea_d
unseared91113942unseared
unweary1335842unweary
uphoard1344572uphoard
afeard1058263_afeard
ahead96817053_ahea_d
anear55420323an_ear_
aneared8512743an_eared
anears63717183an_ears
beard86024963__beard
behead1239923behea_d
chard116124743_ch_ard
cohead123811123cohea_d
debeard1137353debeard
diehard1237053diehard
echard1249223ech_ard
endear74110013endear_
endeared1038053endeared
endears83710053endears
ennead736253ennea_d
hard85443503__h_ard
head87137173__hea_d
hear76143883__hear_
hears86737373__hears
heart85440743__heart
herd84933063__he_rd
hoard94918313__hoard
inboard1037063inboard
inhere9313713inhe_re
inhered11313163inhered
inward10310333in_ward
jughead1933643jughea_d
junkyard2341753junkyard
knead10429663kn_ea_d
lunkhead1642963lunkhea_d
misheard1446253misheard
nard56634453_n__ard
near45236503_n_ear_
neared75119803_n_eared
nears55529423_n_ears
nerd56624943_n_e_rd
onboard1046503onboard
onward1039053on_ward
outhear10910603outhear_
outhears11810393outhears
oxheart1746213oxheart
pinhead13347073pinhea_d
rehear93713223rehear_
rehears103312773rehears
shard96125963_sh_ard
shear85424833_shear_
sheared114516003_sheared
shears93820903_shears
sherd96321153_she_rd
subhead1387693subhea_d
sunward1137653sun_ward
unarm7314453un__arm
unary8315993un__ary
unaware1038033unaware
unbar71913613un_bar_
unbars82113033un_bars
unbearded13146343unbearded
unbend9269773unbe_nd
unbraid1037183unbraid
unceded11410563unceded
unchary1537263unchary
unchewed1735803unchewed
unclad938913uncla_d
unclear936573unclear_
uncleared1237543uncleared
under64624213unde_r_
underarm1147843underarm
undercard1347003undercard
underdo937363unde_rdo
unearned9310063un_earned
unearth1037063un_earth
unease63816643un_ease
uneasy9278853un_easy
unfed94614223unfe__d
ungird887973un_gird
unguards1053993unguards
unhair937333unh_air
unhaired12238763unhaired
unhairs1036373unhairs
unhands1137773unh_ands
unhandy1445513unh_andy
unhang1038443unh_ang
unharmed1438093unh_armed
unhat81119263unh_a_t
unhats91110623unh_ats
unhedged1434973unhedged
unheeded1336893unheeded
unhelm1136863unhe_lm
unhelmed1435993unhelmed
unhelms1234223unhelms
unhelped1435923unhelped
unhewn12285253unhe_wn
unhired112512153unhired
unhood1039233unh_ood
unhoped13249353unhoped
unhurt9311253unh_urt
unideaed1045733unideaed
unitards945623unitards
unitary1038613unitary
unkend11309223unke_nd
unlaid7311753un_laid
unleaded10411333unleaded
unleads8228623unleads
unlearned1035653unlearned
unlearns844453unlearns
unlearnt846403unlearnt
unleased9310713unleased
unleash1034963unleash
unled64021073unle__d
unload73010803unloa_d
unmeant9510903unmeant
unmerry1245023unmerry
unmewed13258173unmewed
unpaid939473un_paid
unready11215943unready
unreal64414453unrea_l
unrepaid1143713unrepaid
unsaid7411833un_said
unseal63315473unsea_l
unsealed91513623unsealed
unseals73212573unseals
unseam83313143unsea_m
unseamed111210663unseamed
unseams9338913unseams
unseat64221023unsea_t
unseated91317683unseated
unseats73012853unseats
unsewed112911023unsewed
unsexed152410253unsexed
unshared121510703unshared
unsharp1235543unsharp
unshed10313773unshe__d
unsmart939603unsmart
unsnarl7107153unsnarl
unswear1035003unswear_
unswears1144023unswears
unteach1246143unteach
unthread1244603unthrea_d
untoward1243193untoward
untread857413untrea_d
unvexed18147103unvexed
unwary1239823un_wary
unweaned1238593unweaned
unwearied1336763unwearied
unweave1336363unweave
unwed94114873unwe__d
unyeaned1237743unyeaned
upbear1096493upbear_
upbears1195423upbears
upheap13105213uphea_p
upheaped1633643upheaped
upheaps1494233upheaps
upheave1544023upheave
upheaved1733763upheaved
upheld12115563uphe_ld
uphoards1443763uphoards
uprear8168793uprear_
upreared1137073upreared
uprears9107493uprears
uptear896783uptear_
uptears9106453uptears
upward12147163u_pward
usher84517763ushe_r_
ushered1139153ushered
ushers94415533ushe_rs

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.390458182.1
2DLD Change Limit1340271866.69020033.9
3Display Results1861860.0762447.4
 (SQL Overall)1786911867.15624970.8
 
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.