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

303 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
berrying1413737(None) 
ferrying15146241ferrying
herrying15147021herrying
serrying12167691serrying
barring104021592barr_ing
bearding124011942bearding
bearing103624772bear_ing
belaying143110602belaying
bellying14359072bellying
belying133612442be_lying
beraking153612972beraking
berating113220762berating
berhyming2042712berhyming
beriming13310462beriming
berming123614832be_rming
berthing14209592berthing
betraying1537712betraying
beworrying1941622beworrying
bewraying1834872bewraying
birring103713062birr_ing
braying134416312b_raying
burring104016992burr_ing
burying133413912b_urying
carrying14148372carrying
currying14196492currying
decrying15237412decrying
erring73816482_err_ing
harrying15157642harrying
herring113615882herr_ing
hurrying15145532hurrying
marrying14157222marrying
parrying14168132parrying
redrying13209022redrying
refrying15278902refrying
retrying122410452retrying
tarrying12146722tarrying
wearying1546702wearying
wherrying1952992wherrying
worrying1534702worrying
aerating92821003aerating
aerifying1636493aerifying
arraying1238753arraying
averring12239063averr_ing
babying1537963b_abying
bandying15218073bandying
barbing123716993b_arbing
barding113822893b_arding
barfing134615093b_arfing
barging114018483b_arging
baring95135853b_ar_ing
barking144724183b_arking
barning104320353b_arning
barraging1337383barraging
barreling1238043barreling
baying125222583b__aying
beaching164114143beaching
beading113221863be_ading
beaming123618803be_aming
beaning103820683be_aning
bearings113912253bear_ings
beating104326873be_ating
becking164416073be_cking
becoming1538163becoming
becriming1646363becriming
becursing1435453becursing
bedding124114483be_dding
bedewing1537143bedewing
bedirtying1742723bedirtying
bedraping1535383bedraping
beefing133911473be_efing
beeping124013913be_eping
beeswing14255763beeswing
beetling1139283beetling
befringe1484513befr_inge
begazing2136633begazing
begging123012653be_gging
begirding1434333begirding
begriming1545533begriming
behaving1735453behaving
behoving1734913behoving
being84920503be___ing
beladying1634763beladying
belching16349153belching
belling103825073be_lling
belting104119133be_lting
bemiring13239603bemiring
bemixing20226523bemixing
bemusing1336613bemusing
benaming1339693benaming
benching163411343benching
bendaying1634953bendaying
bending114420893be_nding
bereaving1537573bereaving
berlin83116373be_rlin_
berline93716853be_rline
berlins93216013be_rlins
berried103714043berr_ied
berries94423553berr_ies
berry104521773berry___
berrylike1842353berrylike
beryline1337083beryline
besting104923923be_sting
betaking153010153betaking
betiding1239913betiding
betting103921403be_tting
beveling143011033beveling
bewaring14279493bewaring
bewearying1942293bewearying
beworming1734553beworming
birching16328463birching
birding114014923b_irding
birling104317053b_irling
birthing14338433birthing
blaring104317113blar_ing
blearing113111943blear_ing
blurbing13326503blurbing
blurring11277233blurring
blurting11258773blurting
boarding123110233boarding
bodying1438973b_odying
bogeying1575703bogeying
boogying1535373boogying
borating113414503borating
boring94724873b_or_ing
borking144716173b_orking
borrowing1544563borrowing
bracing123817613b_racing
braking143917713b_raking
braving133714613b_raving
brazing193715113b_razing
breading123515463breading
breaking153914253breaking
breaming133612513breaming
breeding123411843breeding
breezing20368133breezing
brewing133411153b_rewing
bribing123111043b_ribing
bring85528503b__r_ing
brining103216473b_rining
broking143514823b_roking
bruting102612993b_ruting
bruxing17236823b_ruxing
buddying16274793buddying
bullying14329293bullying
buoying13379953b_uoying
burbling13249423burbling
burgling12239303burgling
burking143716323b_urking
burling104421133b_urling
burning104215503b_urning
burping124012943b_urping
burrowing1544473burrowing
bursting1138703bursting
busying134211993b_usying
buying124213833b__uying
byrling13337373b_yrling
cering94522533ce_r_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
glorying1335543glorying
graying124115883_graying
greying124110893_greying
hearing113324163hear_ing
hearsing1239383hearsing
hearting12513123hearting
heiring113312903heir_ing
herding122915123he_rding
herrings12379533herr_ings
hurraying1654323hurraying
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
nerving112910823ne_rving
obeying1336543obe__ying
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
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
whirrying1962733whirrying
wrying13379623__wrying
xeroxing1534513xeroxing
yearling1297883yearling
yearning1296983yearning
yerking15368813ye_rking
yirring11307763yirr_ing
zeroing1738343ze_roing

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623037.70318974.7
3Display Results3033030.1102754.5
 (SQL Overall)1786913037.96922423.3
 
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.