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

196 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
hepcat1361182(None) 
hepcats1436471hepcats
epact94921532_epact
heat77061422he__at
hellcat12410172hellcat
heptad1237272heptad
hereat93527412hereat
repeat85127212repeat
tipcat10312652tipcat
bearcat11611913bearcat
beat66168303be__at
becap114315053be_cap
begat86629723be_gat
bobcat12411253bobcat
cat58282343___cat
ceca84820783ce_ca_
cecal94619113ce_cal
cercal10314123cercal
cheat105732453che__at
copycat1647593copycat
decaf114919443de_caf
decal85523233de_cal
decant93524223de_cant
decay114718483de_cay
defat95426693de_fat
defeat103817163defeat
depart94720563depart
depict113514793depict
deport94922393deport
depot85727923dep_ot
derat65044083de_rat
descant104315583descant
ducat86225903_ducat
eat36989053_e__at
echt95722903_e_cht
eclat7523603_eclat
enact73525363_enact
epacts105010393_epacts
epha9310053_epha_
ephah1337063_ephah
ephas10311543_ephas
epical10413393_epical
escar74011993_escar
escot75320083_escot
exact143516933_exact
expat14313813_expat
feat76458223fe__at
fecal105119213fe_cal
gelcap1136213gelcap
hapax1739323hap_ax
hat67289963h___at
hazmat20312263hazmat
head87137173he__ad
heal75645693he__al
heap96432893he__ap
hear76143883he__ar
heart85440743he_art
heath115724283he__ath
heats85838403he__ats
heck135826493he_c_k
hecks145220653he_cks
heehaw1543933heehaw
heft106736293he__ft
height134713433height
heist87030913he_ist
heliac111010893heliac
heliast10312073heliast
helical12311153helical
hellcats1346323hellcats
helmet113718933helmet
helot85332683he_lot
helpmate1545603helpmate
hemal104419803he_mal
henbit111412003henbit
hence104920043henc_e
henna84414043henna_
hennas94211803hennas
hent76656383he__nt
hep86644143hep___
hepatic141712773hep_atic
hepper133412663hepper
heppest14228143heppest
heptads1335873heptads
heptane1238363heptane
herbal112513493herbal
heriot9422343heriot
herma105318883herma_
hermae115314473hermae
hermai118912843hermai
hermit11519443hermit
hest75950773he__st
het67674313he___t
hetman112510603hetman
heuch135312333heuc_h
heuchs14447923heuchs
hexad164910623he_xad
heyday1635143heyday
hubcap1553993hubcap
huppah1644183huppah
hypha1637383hypha_
hyphae1746433hyphae
hyphal1736413hyphal
impact122310443impact
ipecac1264623ipecac
kept106232943kep__t
lept66440883lep__t
lepta75714393lepta_
meat66359603me__at
mecca1139933mecca_
meccas1239493meccas
mescal104113483mescal
mezcal19367853mezcal
mudcat11311203mudcat
muscat10314653muscat
neat46356783ne__at
nepeta837893nepeta
ocicat101412813ocicat
pact86648723__pact
pat58089463__p_at
peacoat11412913peacoat
peat65967933__peat
pecan91919033pe_can
peccant13311733peccant
pepla9312863pepla_
phat95837863__phat
plat66048873__plat
prat65952043__prat
react74634333reac_t
recant83228683re_cant
recap95718023re_cap
recast83422773re_cast
recit75235103re_cit
recoat84024273recoat
recta74220263re_cta
recut74729243re_cut
redact9419043redact
redcap1158493redcap
redcoat10410883redcoat
reheat94423943reheat
repack142412163repack
repast83520633repast
repay104818453rep_ay
repeal84718283repeal
repeats94316053repeats
repent84728873repent
replan83215823replan
replant93318533replant
replate93420053replate
replay113412923replay
replot83818593replot
report85326013report
repot75132623rep_ot
reptant92817073reptant
resat55139683re_sat
reseat64131493reseat
scat65848373__scat
seat47575563se__at
secant84023293se_cant
secpar1037923secpar
sect67443623se_c_t
sepal77723003sep_al
sepia75318673sepia_
sepias83616103sepias
sept65844363sep__t
septa75518083septa_
septal84513383septal
septate9511873septate
septet8921133septet
sheepcot15114253sheepcot
spat66548523_sp_at
splat76129343_splat
sprat76635973_sprat
teacart91113193teacart
teat45963633te__at
tecta74215523te_cta
tepa66021683tep_a_
tepal76319583tep_al
tepas76521683tep_as
tercet83624913tercet
theca103311453the_ca_
thecae11299653the_cae
thecal113310303the_cal
thecate123210023the_cate
theocrat1346353theocrat
thereat104315243thereat
tipcart1148833tipcart
tipcats1137103tipcats
tomcat101013453tomcat
topcoat1179313topcoat
upcast102710093_upcast
webcam1545543webcam
webcast1445553webcast
wecht13415443we_cht
wept95635053wep__t
wheat114924573whe__at
whereat134311923whereat

Search took 10 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.1431249587.4
2DLD Change Limit1127161968.68612976.7
3Display Results1961960.1261555.6
 (SQL Overall)1786911968.95519954.3
 
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.