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

260 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
herrying1514702(None) 
berrying14137371berrying
ferrying15146241ferrying
harrying15157641harrying
herring113615881herr_ing
hurrying15145531hurrying
serrying12167691serrying
wherrying1952991wherrying
carrying14148372carrying
currying14196492currying
decrying15237412decrying
erring73816482_err_ing
hearing113324162hear_ing
hearsing1239382hearsing
hearting12513122hearting
heiring113312902heir_ing
herding122915122he_rding
herrings12379532herr_ings
hurraying1654322hurraying
marrying14157222marrying
parrying14168132parrying
redrying13209022redrying
refrying15278902refrying
retrying122410452retrying
tarrying12146722tarrying
wearying1546702wearying
whirrying1962732whirrying
worrying1534702worrying
aerating92821003aerating
aerifying1636493aerifying
arraying1238753arraying
averring12239063averr_ing
barring104021593barr_ing
bearding124011943bearding
bearing103624773bear_ing
belaying143110603belaying
bellying14359073bellying
belying133612443be_lying
beraking153612973beraking
berating113220763berating
berhyming2042713berhyming
beriming13310463beriming
berming123614833be_rming
berthing14209593berthing
betraying1537713betraying
beworrying1941623beworrying
bewraying1834873bewraying
birring103713063birr_ing
braying134416313_braying
burring104016993burr_ing
burying133413913_burying
cering94522533ce_r_ing
charring142913163charr_ing
cheering143612703cheer_ing
chevying2034053che_vying
chirring142610173chirr_ing
churring14298653churr_ing
crying123612283__crying
curring103616843curr_ing
dairying1336353dairying
decaying15239453decaying
decoying15208763decoying
defraying1735853defraying
defying15328823de_fying
deifying1637633deifying
delaying133210973delaying
denying123711293de_nying
derating103222283derating
deriding112512933deriding
deriving132510743deriving
descrying1635103descrying
dirtying1336093dirtying
draying123813843_draying
drying113411603__drying
earing75235483_ear_ing
earning83418213_earning
earring83519013_earring
eddying1335293_eddying
envying1435713_envying
erasing8317963_erasing
erlking1236703_erlking
eroding9314273_eroding
errhine1036593_errhine
espying1336193_espying
eying96117923_e__ying
fearing113520033fear_ing
ferreling13136273ferreling
ferreting13127693ferreting
ferruling13134423ferruling
feruling1258873feruling
flurrying16162803flurrying
foraying1537433foraying
fraying143413433_fraying
frying134511403__frying
furring114013143furr_ing
garring93116713garr_ing
gearing92818843gear_ing
gheraoing1443523gheraoing
glorying1335543glorying
graying124115883_graying
greying124110893_greying
haring104233003h_ar_ing
harking154120943h_arking
harming133717933h_arming
harping134118383h_arping
harrowing1646433harrowing
haying134420613h__aying
heading122919113he_ading
healing113922963he_aling
heaping133015853he_aping
hearings123611853hear_ings
heating114024323he_ating
heaving144114763he_aving
heckling18257163heckling
hedging13348953he_dging
heeding123515063he_eding
heeling113618513he_eling
heezing20349873he_ezing
hefting144510913he_fting
heiling113616363he_iling
heisting123411043heisting
helling114623223he_lling
helloing12159123helloing
helming133712003he_lming
helping133512223he_lping
helving144011133he_lving
hemming15269973he_mming
hennaing1234993hennaing
henting113719653he_nting
heralding1435773heralding
herein93717793he_rein_
heroin94420593he_roin_
heroine103517483he_roine
heroins103518013he_roins
heroizing2248493heroizing
herried113514453herr_ied
herries104025073herr_ies
herry114922473herry___
hewing134514243he__wing
hexing174210513he__xing
hinnying15124853hinnying
hireling121210993hireling
hiring104421603h_ir_ing
hirpling1467223hirpling
hirsling1277543hirsling
hoarding13288643hoarding
hogtying1633553hogtying
honeying1537673honeying
hooraying1644783hooraying
hording123517053h_ording
horning113015003h_orning
horrifying2043983horrifying
horsing113215583h_orsing
hoseying1537193hoseying
howdying1933713howdying
hurdling13288013hurdling
hurling113616413h_urling
hurrahing1643753hurrahing
hurting113914033h_urting
hurtling12318313hurtling
hying126514743h___ying
jarring153613193jarr_ing
jeering153513043jeer_ing
jellying19306173jellying
jemmying2332313jemmying
jerking19308923je_rking
jettying1933953jettying
jurying18337763_jurying
kerbing14308483ke_rbing
kerfing15307533ke_rfing
kerning124010893ke_rning
keying1438043ke__ying
learning978553learning
leering83417643leer_ing
levying1435873le_vying
marring103319553marr_ing
merging112711763me_rging
meriting11314683meriting
metring103215293metr_ing
nearing83020333near_ing
nerving112910833ne_rving
overdrying1846543overdrying
overlying1638003overlying
parring103222063parr_ing
partying14168893partying
pearling11912013pearling
peering103520353peer_ing
perching163711633perching
periling11316863periling
perking143716463pe_rking
perming123416093pe_rming
perusing11811063perusing
praying133717323_praying
predrying1645343predrying
preying133114553_preying
prying124114803__prying
purring104515823purr_ing
quarrying2273733quarrying
querying2135243querying
raying105027193__raying
readying13410223readying
rearing83128783rear_ing
rearming111413613rearming
reburying1535193reburying
rebuying1436743rebuying
recarrying1643653recarrying
reflying15268173reflying
reifying1539383reifying
rekeying1637563rekeying
relaying122515153relaying
relying112914613re_lying
remarrying1643373remarrying
repaying142712393repaying
replying14269403replying
rerising93017783rerising
resaying122512453resaying
retying113213833re_tying
scrying1338663_scrying
scurrying15183833scurrying
searing83330923sear_ing
serging93416673se_rging
sering74731813se_r_ing
serrating10513203serrating
serving113014983se_rving
shearing123915903shear_ing
shearling1336923shearling
sheering123715103sheer_ing
shirring122910443shirr_ing
slurrying13203193slurrying
spraying14299883spraying
storying12249673storying
straying122912693straying
stroying122410593stroying
tarring83318303tarr_ing
tearing84021493tear_ing
terming104016003te_rming
terracing1237703terracing
terrain7410853terrain_
terrains8410323terrains
terrifying1745163terrifying
terrine72517573terr_ine
trying104214073__trying
unerring9311273unerr_ing
updrying1534013updrying
varying1429723_varying
veering113213683veer_ing
verging123812303ve_rging
verifying1936413verifying
versing112314193ve_rsing
warring113717973warr_ing
wearing113318863wear_ing
weirding1335593weirding
whirring15286283whirr_ing
wrying13379623__wrying
xeroxing1534513xeroxing
yearling1297883yearling
yearning1296983yearning
yerking15368813ye_rking
yirring11307763yirr_ing
zeroing1738343ze_roing

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622607.70318974.7
3Display Results2602600.0932795.7
 (SQL Overall)1786912608.21621749.1
 
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.