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

162 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
hepcats143647(None) 
hepcat13611821hepcat_
epacts105010392_epacts
heats85838402he__ats
hellcats1346322hellcats
heptads1335872heptads
repeats94316052repeats
tipcats1137102tipcats
bearcats1267023bearcats
beats76042243be__ats
becaps123811403be_caps
bobcats1335993bobcats
cats66356343___cats
cheats114519543che__ats
copycats1745083copycats
decafs124010883de_cafs
decals93717713de_cals
decants103514443de_cants
decays124612913de_cays
defats105114553de_fats
defeats113511233defeats
departs104310683departs
depicts12358463depicts
deports105012883deports
depots94716343dep_ots
derats74625063de_rats
descants112910143descants
ducats95011763_ducats
eats47054873_e__ats
eclats8313033_eclats
enacts84012973_enacts
epact94921533_epact_
ephahs1435503_ephahs
ephas10311543_epha_s
escars83913133_escars
escots84211743_escots
exacts15359613_exacts
expats1537683_expats
feats86432753fe__ats
gelcaps1235203gelcaps
hats76858253h___ats
hazmats2136603hazmats
heads95127113he__ads
heals85733453he__als
heaps105223223he__aps
hears86737373he__ars
hearts96218943he_arts
heat77061423he__at_
heath115724283he__ath
heaths126316383he__aths
hecks145220653he_c_ks
heehaws1643343heehaws
hefts116218153he__fts
heights14399443heights
heists96814633he_ists
heliast10312073heliast
heliasts1136103heliasts
hellcat12410173hellcat_
helmets12309073helmets
helots95217703he_lots
helpmate1545603helpmate
helpmates1645513helpmates
henbits12177003henbits
hennas94211803henna_s
hents87330743he__nts
hepatic141712773hep_atic
hepatics15198933hep_atics
heppest14228153heppest
heptad1237273hepta_d
heptane1238363heptane
heptanes1339003heptanes
herbals122710603herbals
hereat93527413hereat_
heriots10312063heriots
hermits12312143hermits
hests85829933he__sts
hetmans12187593hetmans
hets75547203he___ts
heuchs14447923heuc_hs
hexads17468193he_xads
heydays1734143heydays
hubcaps1643543hubcaps
huppahs1743333huppahs
impacts13266503impacts
ipecacs1354503ipecacs
meats75034053me__ats
meccas1239493mecca_s
mescals112911563mescals
mezcals20246533mezcals
mudcats1236223mudcats
muscats1138933muscats
neats55931903ne__ats
nepetas935943nepetas
ocicats11137413ocicats
pacts95125803__pacts
pats66460853__p_ats
peacoats1247833peacoats
peats76140193__peats
pecans101515833pe_cans
plats75531373__plats
prats76333393__prats
reacts83616603reac_ts
recants93217093re_cants
recaps103615733re_caps
recast83422773re_cast
recasts93413533re_casts
recits83621353re_cits
recoats92616643recoats
recuts83817373re_cuts
redacts10510943redacts
redcaps1247073redcaps
redcoats1147123redcoats
reheats104513523reheats
repacks15269543repacks
repass84114703rep_ass
repast83520633rep_ast
repasts93611933repasts
repays113813973rep_ays
repeals94014523repeals
repeat85127213repeat_
repents93717623repents
replans92814943replans
replants102811243replants
replate93420053replate
replates102919273replates
replays12399763replays
replots93412633replots
reports94916213reports
repots85621003rep_ots
reseats74319583reseats
scats75930603__scats
seats54844343se__ats
secants93413893se_cants
secpars1138413secpars
sects75622893se_c_ts
sepals85217373sep_als
sepias83616103sepia_s
septate9511873septate
septets998953septets
septs75420603sep__ts
sheepcots1682683sheepcots
spats75031383_sp_ats
splats84817303_splats
sprats85819933_sprats
teacarts10116073teacarts
teats55636813te__ats
tepals85415043tep_als
tepas76521683tep_a_s
tercets93512443tercets
thecate123210023the_cate
theocrats1464683theocrats
tipcarts1244573tipcarts
tipcat10312653tipcat_
tomcats11127773tomcats
topcoats1245193topcoats
upcast102710093_upcast
upcasts11185643_upcasts
webcams1643073webcams
webcast1445553webcast
webcasts1543313webcasts
wechts1446253we_chts
wheats125013223whe__ats

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 Limit1340271626.59320328.7
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.04625360.6
 
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.