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 “heart” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

159 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
heart8544074(None) 
hart76865771h_art
hear76143881hear_
heard95222751heard
hears86737371hears
hearth125315211hearth
hearts96218941hearts
hearty126313631hearty
heat77061421hea_t
peart76440751peart
apart74330672apart
art38679142__art
bear66844642bear_
beard86024962beard
bears75739042bears
beast76338642beast
beat66168302bea_t
beaut75135212beaut
boart78835932boart
cart66570342_cart
chart105038282chart
cheat105732452chea_t
chert105232102che_rt
dart55857872_dart
dealt65234282dealt
dear55343602dear_
dears65736882dears
dearth104212512dearth
deary95826842deary
depart94720562depart
derat65044082derat
ear36867882_ear_
earl45838142_earl
earn46737552_earn
ears46356592_ears
earth85023052_earth
east46659102_east
eat36989052_ea_t
fart76860562_fart
fear75337792fear_
fears84829392fears
feast85932722feast
feat76458222fea_t
gear55934972gear_
gears64628692gears
haar77323492haar_
haars85620472haars
haet75659502h_aet
haft105941842h_aft
halt76056302h_alt
hant75461582h_ant
hard85443502h_ard
hare76255732h_are
hark115237392h_ark
harl75740002h_arl
harm95637792h_arm
harp96134282h_arp
harts88441592h_arts
hast76259482h_ast
hat67289962h_a_t
haut75949732h_aut
head87137172hea_d
heads95127112heads
heady125117262heady
heal75645692hea_l
heals85733452heals
health124712142health
heap96432892hea_p
heaps105223222heaps
heapy135914982heapy
hearer94323642hearer
hearse94114272hearse
hearted113314022hearted
hearten102411752hearten
hearths135311072hearths
heath115724282heath
heats85838402heats
heave114521812heave
heavy144814182heavy
heft106736292he_ft
hegari1039512hegari
heir77523802heir_
heirs85618562heirs
heist87030912heist
helot85332682helot
henry114014472henry
hent76656382he_nt
her66547812he_r_
herb94730962he_rb
herd84933062he_rd
here76447102he_re
herl75834552he_rl
herm95636152he_rm
hern76134892he_rn
hero74635782he_ro
herry114922472herry
hers75844872he_rs
hertz174919032he_rtz
hest75950772he_st
het67674312he__t
hoar76729162hoar_
hoard94918312hoard
hoars85925542hoars
hoary114516762hoary
hurt77142572h_urt
kart86750802_kart
leant56737782leant
leapt75027472leapt
lear47045952lear_
learn55322662learn
learnt64019252learnt
lears55938732lears
leary85927382leary
least56134882least
lyart85121882lyart
mart66865972_mart
meant76537202meant
meat66359602mea_t
near45236502near_
nears55529422nears
neat46356782nea_t
oxheart1746212oxheart
part65967462_part
pear69745232pear_
pearl75324462pearl
pears75138612pears
peat65967932pea_t
pert66759322pe_rt
quart144027852quart
react74634332react
rear45644552rear_
rearm75923562rearm
rears54739652rears
scart76139772scart
sear47353842sear_
sears54744912sears
seat47575562sea_t
shear85424832shear_
shears93820902shears
smart75834092smart
start55642312start
swart86234642swart
tart47566182_tart
tear45242882tear_
tears55436462tears
teary85124052teary
teat45963632tea_t
thwart12311682thwart
vert77249372ve_rt
wart77866082_wart
wear75836722wear_
wears86030302wears
weary115620612weary
wert79749822we_rt
wheat114924572whea_t
year76534252year_
yearn86316432yearn
years84527672years
yeast85327942yeast

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001591.37639098.8
3Display Results1591590.0305300.0
 (SQL Overall)1786911591.499119206.8
 
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.