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

364 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
serrying1216769(None) 
berrying14137371berrying
ferrying15146241ferrying
herrying15147021herrying
carrying14148372carrying
currying14196492currying
decrying15237412decrying
erring73816482_err_ing
harrying15157642harrying
herring113615882herr_ing
hurrying15145532hurrying
marrying14157222marrying
parrying14168132parrying
redrying13209022redrying
refrying15278902refrying
retrying122410452retrying
scrying1338662s_crying
scurrying15183832scurrying
searing83330922sear_ing
serging93416672se_rging
sering74731812se_r_ing
serrating10513202serrating
serving113014982se_rving
slurrying13203192slurrying
spraying14299882spraying
storying12249672storying
straying122912692straying
stroying122410592stroying
tarrying12146722tarrying
wearying1546702wearying
wherrying1952992wherrying
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
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
essaying1235033essaying
estraying1338293estraying
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
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
sabring102614843sabr_ing
sacring103115983sacr_ing
salarying1336073salarying
sallying12309853sallying
savvying1862723savvying
saying104325543s__aying
scarfing14309713scarfing
scaring103421973scar_ing
scarping133312463scarping
scarring112511513scarring
scarting113415263scarting
scoring103117213scor_ing
scorning1169133scorning
scraping133310863scraping
screwing14288233screwing
scribing13238183scribing
scriving14258763scriving
seagoing1038193seagoing
sealing83528563se_aling
seaming103222113se_aming
searching1538343searching
seating84130683se_ating
seceding12288563seceding
secerning1246203secerning
secreting1279823secreting
securing11310413securing
sedating103014113sedating
seducing1236503seducing
seeding93719483se_eding
seedling102610953seedling
seeing74222143se__eing
seeking124016063se_eking
seeling83522003se_eling
seeming103216263se_eming
seeping103817913se_eping
seething1239023seething
segueing1034983segueing
seining84020773se_ining
seising84018863se_ising
seizing174114833se_izing
selfing112911623se_lfing
selling83225833se_lling
semidrying1742373semidrying
sending94221373se_nding
sensing84116953se_nsing
serein63318463se_rein_
sereins73716113se_reins
sergings10299213se_rgings
seriating10916403seriating
sericin9312843sericin_
sericins10312463sericins
serin55434443se_r_in_
serine65432673se_r_ine
seringa83310743se_r_inga
serins64029673se_r_ins
serotine8313573serotine
serotiny1148573serotiny
serotyping1643123serotyping
serranid947573serranid
serrano768463serr_ano
serried82513963serr_ied
serries73925353serr_ies
serry84824123serry___
servicing1545343servicing
servings12249223se_rvings
setting83621393se_tting
settling978943settling
severing122013853severing
sewering122411093sewering
sewing103819623se__wing
sexing144313893se__xing
sharing113723243shar_ing
sharking163912973sharking
sharping143011373sharping
shearing123915903shear_ing
shearling1336923shearling
sheering123715103sheer_ing
shirking163210473shirking
shirring122910443shirring
shirting123213613shirting
shoring112820073shor_ing
shorting122514803shorting
shrewing15228093shrewing
shrining122610853shrining
shriving15268453shriving
shying134211843s__hying
siring75128313s_ir_ing
siruping1136503siruping
skirling13249063skirling
skirring13297143skirring
skirting13289393skirting
skying14399983s__kying
slaying113316843s_laying
slurping11278123slurping
slurring9288833slurring
smarting113212453smarting
smearing113511753smear_ing
smerking15258473smerking
smirking15277233smirking
snarfing12358663snarfing
snaring83920953snar_ing
snarling92513183snarling
sneering93414503sneer_ing
snoring83917203snor_ing
snorting92613373snorting
soaring83521893soar_ing
sorbing102815263s_orbing
soring74731883s_or_ing
sorning83116813s_orning
sorrowing1344873sorrowing
sorting83221813s_orting
sourcing1158353sourcing
souring83219063sour_ing
sparging122611133sparging
sparing104823873spar_ing
sparking152812543sparking
sparling112714533sparling
sparring113112223sparring
spaying133014623s_paying
spearing113216103spear_ing
speering113116323speer_ing
speiring113711263speir_ing
spiring103918183spir_ing
spirting112913633spirting
splaying14219303splaying
sporing104319413spor_ing
sporting112415463sporting
spring94526013s_pr_ing
sprucing1336893sprucing
spurning11258663spurning
spurring11339763spurring
spurting113111633spurting
spying123913253s__pying
staring84527053star_ing
starling93017123starling
starring92312953starring
starting93116173starting
starving122510173starving
staying114017323s_taying
steadying14154503steadying
steering93916793steer_ing
stereoing1037893stereoing
sterling93615553sterling
stimying1437503stimying
stirring9299653stirring
storing83921123stor_ing
storming11209423storming
strafing122111193strafing
strawing122411623strawing
strewing12289853strewing
striding102713603striding
striking133012233striking
string75327563s_tr_ing
striping112612523striping
striving122611393striving
stroking132610943stroking
strowing122310563strowing
studying1335553studying
stying105414573s__tying
stymying1733963stymying
subring104116263subr_ing
sullying12328513sullying
superlying1645383superlying
surfing112914483s_urfing
surging93115433s_urging
surveying1644963surveying
swarding1359003swarding
swarming1458223swarming
swaying143610643s_waying
swearing123711443swear_ing
swerving1546113swerving
swirling12249143swirling
syruping1434253syruping
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.406440125.6
2DLD Change Limit1461623646.65621959.4
3Display Results3643640.1562333.3
 (SQL Overall)1786913647.21824756.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.