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

269 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
ferrying1514624(None) 
berrying14137371berrying
herrying15147021herrying
serrying12167691serrying
carrying14148372carrying
currying14196492currying
decrying15237412decrying
erring73816482_err_ing
fearing113520032fear_ing
ferreling13136272ferreling
ferreting13127692ferreting
ferruling13134422ferruling
feruling1258872feruling
flurrying16162802flurrying
foraying1537432foraying
fraying143413432f_raying
frying134511402f__rying
furring114013142furr_ing
harrying15157642harrying
herring113615882herr_ing
hurrying15145532hurrying
marrying14157222marrying
parrying14168132parrying
redrying13209022redrying
refrying15278902refrying
retrying122410452retrying
tarrying12146722tarrying
wearying1546702wearying
wherrying1952992wherrying
worrying1534702worrying
aerating92821003aerating
aerifying1636493aerifying
affraying1943103affraying
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
deferring1436143deferr_ing
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
fairing113614013fair_ing
fancying1735353fancying
farcing133514003f_arcing
farding123716743f_arding
faring105231283f_ar_ing
farming133515083f_arming
farrowing1645873farrowing
farthing1538073farthing
farting114120753f_arting
faying134521073f__aying
feasing113916653fe_asing
feasting122011323feasting
feazing205411443fe_azing
fedexing2034493fedexing
feeding123515073fe_eding
feeing104416503fe__eing
feeling113617073fe_eling
feezing204610163fe_ezing
feigning1335813feigning
feinting123410833feinting
felling113321133fe_lling
felting113515213fe_lting
fencing132411133fe_ncing
fending123717603fe_nding
feoffing1432963feoffing
ferine96422583fe_r_ine
ferrelling1445063ferrelling
ferretings14133493ferretings
ferriage1245463ferr_iage
ferric1139993ferr_i_c
ferried113411523ferr_ied
ferries103521083ferr_ies
ferrite103312753ferr_ite
ferritin1147383ferritin_
ferritins1247273ferritins
ferrotyping2052163ferrotyping
ferry116020803ferry___
ferryman1643813ferryman
ferrymen1643943ferrymen
fessing113812863fe_ssing
fetching17298413fetching
feting104417793fe__ting
fetting113517873fe_tting
fettling1266773fettling
feuding123410263fe_uding
feuing104412273fe__uing
fevering152510083fevering
firing104021723f_ir_ing
firming132811223f_irming
flaring114116803flar_ing
flaying143914463f_laying
fleering123811283fleer_ing
fleying14329873f_leying
flirting12319013flirting
flying134612153f__lying
foraging1358063foraging
forcing134013753f_orcing
fording123717043f_ording
fordoing1357303fordoing
forewing1539003forewing
forging124114723f_orging
forgoing1366853forgoing
forking154014843f_orking
forming133615733f_orming
framing133014793f_raming
frayings15325993f_rayings
freaking163611453freaking
freeing113713913f_reeing
freezing21308323freezing
frenzying2542413frenzying
freshing152611023freshing
fretting122711523fretting
frizing203310873f_rizing
furling114016563f_urling
furrings12317143furr_ings
furrowing1644063furrowing
garring93116713garr_ing
gearing92818843gear_ing
glorying1335543glorying
graying124115883_graying
greying124110893_greying
hearing113324163hear_ing
hearsing1239383hearsing
hearting12513123hearting
heiring113312903heir_ing
herding122915123he_rding
herrings12379533herr_ings
hurraying1654323hurraying
inferring1338613inferr_ing
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
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
referring1338033referr_ing
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 7 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 Limit1461622696.69021847.8
3Display Results2692690.1102445.5
 (SQL Overall)1786912696.95625688.8
 
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.