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

211 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
reheard1130902(None) 
rehear93713221rehear_
rehears103312771rehears
behead1239922behea_d
debeard1137352debeard
heard95222752__heard
reboard10310762reboard
redear73515172redear_
redears82814452redears
redhead1257052redhea_d
reearn6612142re_earn
regard85215772re_gard
regear73512742regear_
regeared1039432regeared
regears83012462regears
rehearse11296662rehearse
rehearsed13305922rehearsed
reheat94423942rehea_t
reheated122415002reheated
reheats104513522reheats
relearn747972relearn
reread71715432rerea_d
rereward1246142rereward
retard75018932re_tard
retear63115482retear_
retears72814922retears
reward106017642re_ward
rewear93012002rewear_
rewears102911042rewears
reynard1135122reynard
unheard1136942unheard
afeard1058263_afeard
ahead96817053_ahea_d
barehead1446603barehea_d
beard86024963__beard
bedward1497473bedward
beeyard1335523beeyard
beheaded1536373beheaded
beheads1338523beheads
beheld1236413behe_ld
beweary1536223beweary
chard116124743_ch_ard
cohead123811123cohea_d
debeards1235503debeards
delead84112343delea_d
diehard1237053dieh_ard
echard1249223_echard
forehead1537893forehea_d
freehand1574993freehand
hard85443503__h_ard
head87137173__hea_d
hear76143883__hear_
hears86737373__hears
heart85440743__heart
herd84933063__he_rd
hoard94918313__hoard
jehad1637683jeh_a_d
jeopard1744113jeopard
keycard1743663keycard
leeward1135783leeward
leopard1045293leopard
leotard846193leotard
misheard1446253misheard
orchard1346933orch_ard
outheard1288543outheard
overheard16246623overheard
oxheart1746213oxheart
petard95013803pe_tard
preboard1338263preboard
preheat12413893prehea_t
preheated1539813preheated
preheats1339413preheats
read55942533r__ea_d
readd74617133r__eadd
rear45644553r__ear_
reared75930013r__eared
rearm75923573r__earm
rears54739653r__ears
rearward1245783rearward
rebar75420193re_bar_
rebars84019833re_bars
reboards1138773reboards
receded112713043receded
rechart12314343rechart
recheat12415933rechea_t
recheats1339193recheats
rechewed1735633rechewed
reclad9311873recla_d
record96117433re_cord
redbird1155263redbird
reded74829123rede__d
redemand1245923redemand
redheaded1545083redheaded
redheads1336173redheads
redware1139363redware
reearned948893re_earned
reearns749103re_earns
reed55549623re_e__d
reeded84022563re_eded
reefed103816583re_efed
reeked113717643re_eked
reeled74725533re_eled
reeved104118713re_eved
refed93921923refe__d
refeed104717623refe_ed
refer84822143refe_r_
referred1297833referred
refers93921083refe_rs
regards94112563re_gards
rehab10312443reh_a_b
rehabs1139023reh_abs
rehang1039823reh_ang
reharden1276303reh_arden
rehash1237433reh_ash
rehearing132211763rehearing
rehearsal1242343rehearsal
rehearser12265033rehearser
rehearses12286853rehearses
reheater113413033reheater
reheaters122010273reheaters
reheel93610823rehe_el
reheeled1236773reheeled
reheels10298253reheels
rehem103815353rehe__m
rehemmed1634153rehemmed
rehems113410983rehe_ms
rehire95415863reh_ire
rehired115013153rehired
rekeyed1536163rekeyed
relaid75518443re_laid
reland75920433re_land
relearned1035643relearned
relearns836303relearns
relearnt849213relearnt
release7312763release
released9310243released
relend76116453rele_nd
reload7413893reloa_d
remand95618963re_mand
remark123512373re_mark
remend95216553reme_nd
reneged92010763reneged
renewed11309993renewed
repaid94716323re_paid
repand95316063re_pand
repark123511713re_park
repeal84718293repea_l
repealed113211873repealed
repeals94014533repeals
repeat85127213repea_t
repeated113117443repeated
repeats94316053repeats
reperk122511773repe_rk
replead10399013replea_d
rereads81512293rereads
rerecord1145373rerecord
rerewards1344643rerewards
resaid74517083re_said
reseal64819653resea_l
resealed92713973resealed
reseals73917683reseals
research1344553research
reseat64131493resea_t
reseated93220263reseated
reseats74319583reseats
reseau64216213resea_u
reseaus74012153reseaus
reseaux14326233reseaux
reseed74823293rese_ed
resend75016773rese_nd
resewed113011833resewed
restart7320033restart
retards85015003re_tards
reteach1237413reteach
reteam83214533retea_m
reteamed1138013reteamed
reteams9339563reteams
rethread1245353rethrea_d
retiary1038333retiary
retread849003retrea_d
reveal94115063revea_l
revealed123211213revealed
reveals103812733reveals
reveled113917753reveled
revelry1335693revelry
reverb113912573reve_rb
revere94621253reve_re
revered112819333revered
revers94529633reve_rs
revert93529113reve_rt
revery124014213reve_ry
rewards114813993re_wards
rewarm115913493re_warm
reweave1336773reweave
reweaved1535953reweaved
rewed95425453rewe__d
reweld103711113rewe_ld
reword106321413re_word
reynards1244303reynards
rezero1578873reze_ro
rhea75017433r_hea__
rheas84816953r_hea_s
ritard74812083r_itard
seaward1148183seaward
shard96125963_sh_ard
shear85424833_shear_
sheared114516013_sheared
shears93820903_shears
sherd96321153_she_rd
sorehead1246973sorehea_d
uphoard1344573uphoard

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 Filter1786911340270.423422437.4
2DLD Change Limit1340272117.53017799.1
3Display Results2112110.0762776.3
 (SQL Overall)1786912118.02922255.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.