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

521 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
yearling129788(None) 
pearling11912011pearling
yealing112716381yea_ling
yeanling12107061yeanling
yearlings1384201yearlings
yearlong12102571yearlong
yearning1296981yearning
bearding124011942bearding
bearing103624772bear_ing
carling103727062_carling
darling93418362_darling
dealing94323232dea_ling
eagling91113602_eagling
eanling81416672_eanling
earing75235482_ear_ing
earning83418212_earning
earring83519012_earring
fearing113520032fear_ing
gearing92818842gear_ing
gnarling10217602gnarling
healing113922962hea_ling
hearing113324162hear_ing
hearsing1239382hearsing
hearting12513122hearting
learning978552learning
marling103322762_marling
nearing83020332near_ing
parling103823762_parling
pealing104123202pea_ling
rearing83128782rear_ing
rearming111413612rearming
sealing83528562sea_ling
searing83330922sear_ing
shearling1336922shearling
snarling92513182snarling
sparling112714532sparling
starling93017122starling
tearing84021492tear_ing
teazling1856572teazling
vealing114217422vea_ling
weakling16106762weakling
weanling12118642weanling
wearing113318862wear_ing
wearying1546702wearying
yarding123413142y_arding
yarning113512952y_arning
yawling14369182y_awling
yealings12257702yea_lings
yeaning113814632yea_ning
yeanlings1393692yeanlings
yearlies1137602yearlies
yearnings1393552yearnings
yeasting12188922yeasting
yelling113516702ye_lling
yerking15368812ye_rking
aerating92821003aerating
ailing74331013__ailing
alarming1138583alarming
anearing9413973anear_ing
arcing95819643__arcing
argling92812733__argling
arming94719803__arming
availing1267283availing
awarding1356043awarding
bailing103723523_bailing
baling94829693_ba_ling
balling104424763_balling
barbing123716993_barbing
barding113822893_barding
barfing134615093_barfing
barging114018483_barging
baring95135853_bar_ing
barking144724183_barking
barning104320353_barning
barring104021593_barring
bawling133813863_bawling
beaching164114143beaching
beading113221863bea_ding
beaming123618803bea_ming
beaning103820683bea_ning
bearings113912253bear_ings
bearlike14156793bearlike
beating104326873bea_ting
beetling1139283beetling
befalling15226503befalling
begalling13216493begalling
belling103825073be_lling
beraking153612973beraking
berating113220763berating
berlin83116373be_rlin_
berline93716853be_rline
berlins93216013be_rlins
berming123614833be_rming
berrying14137373berrying
beveling143011033beveling
bewailing1536063bewailing
bewaring14279493bewar_ing
birling104317053_birling
blaring104317113blar_ing
blearing113111943blear_ing
boarding123110233boarding
brailing113514793brailing
brawling143210043brawling
burling104421133_burling
byrling13337373_byrling
cabling124017553_cabling
calling103826773_calling
carding113922433_carding
caring95137993_car_ing
carking144322853_carking
carlin84421823_carlin_
carline93923613_carline
carlings114015853_carlings
carlins93921913_carlins
caroling113317003_caroling
carping123521083_carping
carting104228283_carting
carving133916773_carving
catling104819793_catling
ceasing104118263cea_sing
ceiling103416723ce_iling
celling103921263ce_lling
cering94522533ce_r_ing
charging152910773charging
charing133721323char_ing
charking183512613charking
charming163012033charming
charring142913163charring
charting142614193charting
clearing113014883clear_ing
clearwing1533673clearwing
coaling103722823coa_ling
craaling112711353craaling
cradling122411453cradling
crawling143110513crawling
curling104320183_curling
daring84928683_dar_ing
darking134217343_darking
darkling1437483_darkling
darlings103710383_darlings
darning93817333_darning
darting94020663_darting
dartling1039563_dartling
deadline10139053deadline
deairing10311893deairing
dealings103510703dea_lings
deaning94020473dea_ning
deashing134210953deashing
deaving123814753dea_ving
debarking1735383debarking
debarring1335713debarring
decrying15237413decrying
defiling132812463defiling
demarking1736773demarking
departing1349513departing
derailing112011313derailing
derating103222283derating
detailing112510413detailing
develing133212733develing
deviling1311812853deviling
dialing94318173dia_ling
dialling10310783dialling
dirling93316073_dirling
drawling13318673drawling
dwarfing1633613dwarfing
eanlings9128473_eanlings
earings84517713_ear_ings
earlier72612743_earlier
earnings9419333_earnings
earrings9299633_earrings
earthing12310323_earthing
earthling1346193_earthling
earwig10114703_earwi_g
easing74926463_ea_sing
easting84924303_easting
eating75134403_ea_ting
emailing113010043emailing
enabling1138603enabling
erasing8317963_erasing
erlking1236703_e_rlking
erring73816483_e_rring
exiling15311083_exiling
eyeballing1642263eyeballing
fabling133413623_fabling
failing113521333_failing
falling113621583_falling
farcing133514003_farcing
farding123716743_farding
faring105231283_far_ing
farming133515083_farming
farting114120753_farting
fatling113815683_fatling
feasing113916653fea_sing
feasting122011323feasting
feazing205411443fea_zing
feeling113617073fe_eling
felling113321133fe_lling
fenagling1434553fenagling
ferreling13136273ferreling
ferruling13134423ferruling
ferrying15146243ferrying
feruling1258873feruling
fettling1266773fettling
flailing12298923flailing
flaring114116803flar_ing
flatling123410013flatling
foaling113515843foa_ling
furling114016563_furling
gabling113514543_gabling
galling93921963_galling
gaoling93314653_gaoling
garbing113613273_garbing
garbling12249453_garbling
gargling11239203_gargling
garring93116713_garring
gearings10359503gear_ings
gelling93219763ge_lling
gentling1048453gentling
glaring93714883glar_ing
gnarring10225973gnarring
goaling93515333goa_ling
grayling1338003grayling
guarding1136523guarding
hailing113820693_hailing
haling104229783_ha_ling
haring104233003_har_ing
harking154120943_harking
harming133717933_harming
harping134118383_harping
hauling113714433_hauling
heading122919113hea_ding
headline12129613headline
headlong1334123headlong
heaping133015853hea_ping
hearings123611853hear_ings
heating114024323hea_ting
heaving144114763hea_ving
heckling18257163heckling
heeling113618513he_eling
heiling113616363he_iling
heiring113312903heir_ing
helling114623223he_lling
heralding1435773heralding
herding122915123he_rding
herring113615883he_rring
herrying15147023herrying
hoarding13288643hoarding
hurling113616413_hurling
impearling1543063impearling
inarming1138343inarming
jailing153415843_jailing
jarring153613193_jarring
jeering153513043jeer_ing
jelling153516613je_lling
jerking19308923je_rking
jeweling1935483jeweling
karting123716063_karting
keckling14245523keckling
keeling123515123ke_eling
kegling13309363ke_gling
kerbing14308483ke_rbing
kerfing15307533ke_rfing
kerning124010893ke_rning
knurling1344943knurling
kraaling13186663kraaling
ladling92813393_ladling
lalling83519623_lalling
larding92917873_larding
larking123718253_larking
leaching143012833leaching
leading93419553lea_ding
leafing113313583lea_fing
leaguing1035343leaguing
leaking123616973lea_king
leaning83721203lea_ning
leaping103215993lea_ping
learnings1094323learnings
leashing123310313leashing
leasing83920163lea_sing
leaving114216853lea_ving
leering83417643leer_ing
leveling122910433leveling
mailing102923343_mailing
malling103623663_malling
marbling13179883_marbling
marking144020133_marking
marlin84220903_marlin_
marline93320953_marline
marlings113713493_marlings
marlins93420473_marlins
marring103319553_marring
marting103325013_marting
mauling103315683_mauling
meaning103918703mea_ning
medaling121912263medaling
medalling1346923medalling
meddling13257933meddling
melling102822623me_lling
merging112711763me_rging
merlin83916683me_rlin_
merlins93015813me_rlins
metaling111613723metaling
metalling1249593metalling
metring103215293metr_ing
mewling13329513me_wling
miauling1137343miauling
nailing83419963_nailing
narking124015383_narking
nearlier836793nearlier
needling10248753needling
nerving112910833ne_rving
nestling958893nestling
nettling957213nettling
nurling84215823_nurling
oaring74225303_oar_ing
paling93530133_pa_ling
palling104024483_palling
parging113318603_parging
paring94236493_par_ing
parking143423043_parking
paroling113316213_paroling
parring103222063_parring
parsing103819553_parsing
parting103527383_parting
peaching163613643peaching
peacing124117073pea_cing
peaking144317693pea_king
pearlier1037323pearlier
pearlite1039443pearlite
pebbling1535073pebbling
pedaling122412133pedaling
pedalling1346663pedalling
peddling13217973peddling
peeling102919873pe_eling
peering103520353peer_ing
peopling1338353peopling
periling11316863periling
perking143716463pe_rking
perming123416093pe_rming
pestling111010253pestling
pettling1168213pettling
pharming16248143pharming
prearming14139223prearming
purling103620293_purling
quailing1838403quailing
railing83325643_railing
raring74332873_rar_ing
reaching143317203reaching
reacting113317893reacting
readding11411363readding
reading93327213rea_ding
readying13410223readying
realign838763rea_lign
reaming103924013rea_ming
reaping103621213rea_ping
rearguing1135603rearguing
reaving113820533rea_ving
recalling122211903recalling
reddling112911813reddling
redrying13209023redrying
reearning1039053reearning
reedling102414273reedling
reeling83126863re_eling
refalling132010423refalling
refiling123116533refiling
refrying15278903refrying
regaling10315363regaling
regarding12149153regarding
remailing122412473remailing
remarking1638893remarking
renailing102813333renailing
reoiling93217213reoiling
reparking1638923reparking
resailing103314253resailing
resiling93520173resiling
resoling92916303resoling
retailing103214733retailing
retarding111110653retarding
retiling93319483retiling
retrying122410453retrying
reveling123117083reveling
reviling122917213reviling
rewarding14148833rewarding
rewarming15147383rewarming
roaring82916003roar_ing
sailing83927373_sailing
sapling103217863_sapling
scaling103519373sca_ling
scarfing14309713scarfing
scaring103421973scar_ing
scarping133312463scarping
scarring112511513scarring
scarting113415263scarting
seagoing1038193seagoing
seaming103222113sea_ming
searching1538343searching
seating84130683sea_ting
seedling102610953seedling
seeling83522003se_eling
selling83225833se_lling
serging93416673se_rging
sering74731813se_r_ing
serrying12167693serrying
serving113014983se_rving
settling978943settling
sharing113723243shar_ing
sharking163912973sharking
sharping143011373sharping
shauling1249393shauling
shawling1558223shawling
shealing123415463shea_ling
shearing123915903shear_ing
shearlings1443533shearlings
skirling13249063skirling
smarting113212453smarting
smearing113511753smear_ing
snailing92912973snailing
snarfing12358663snarfing
snaring83920953snar_ing
soaring83521893soar_ing
spalling113213463spalling
sparging122611133sparging
sparing104823873spar_ing
sparking152812543sparking
sparkling16226353sparkling
sparlings12257153sparlings
sparring113112223sparring
spearing113216103spear_ing
stabling112913653stabling
staling83925423sta_ling
stalling95116703stalling
stapling112813153stapling
staring84527053star_ing
starlings10237923starlings
starring92312953starring
starting93116173starting
startling1037373startling
starving122510173starving
stealing93416603stea_ling
sterling93615553sterling
swarding1359003swarding
swarming1458223swarming
swearing123711443swear_ing
swirling12249143swirling
tabling103216033_tabling
tailing82923103_tailing
taring73932283_tar_ing
tarring83318303_tarring
tarting84222653_tarting
teaching143612603teaching
teaming103917593tea_ming
teaseling1036913teaseling
teasing83918513tea_sing
teazeling1934543teazeling
telling83321083te_lling
terming104016003te_rming
thirling12248583thirling
tirling83315733_tirling
trailing92916093trailing
trawling122710783trawling
treadling1137503treadling
twirling12246243twirling
unarming1138623unarming
vailing113817943_vailing
varying1429723_varying
veering113213683veer_ing
veiling113615293ve_iling
verging123812303ve_rging
versing112314193ve_rsing
vialing113614163via_ling
vialling1237223vialling
wailing113620903_wailing
waling104525303_wa_ling
walling113520973_walling
warbling14198943_warbling
warding123918143_warding
waring105029443_war_ing
warking153519573_warking
warming133515083_warming
warning113717093_warning
warping133715183_warping
warring113717973_warring
warsling12198593_warsling
wauling112713113_wauling
wawling143810963_wawling
weaklings1794003weaklings
weaning114117193wea_ning
weanlings1394413weanlings
weaseling1335613weaseling
weaving143211623wea_ving
wedeling1338773wedeling
weirding1335593weirding
welling112920313we_lling
whaling143910773wha_ling
wharfing1834683wharfing
whirling15237163whirling
yacking174315683y_acking
yaffing17337823y_affing
yakking14376423y_akking
yanking154512463y_anking
yapping153412613y_apping
yauping13357243y_auping
yawing134215613y_a_wing
yawning14378343y_awning
yawping16357333y_awping
yearend11285703year_end
yearly125210273yearl__y
yearn86316433year__n_
yearningly1743383yearningly
yearns9509543year__ns
yeelin939343ye_elin_
yeelins1038813ye_elins
yelping13317873ye_lping
yenning11369493ye_nning
yessing113210063ye_ssing
yeuking15286123ye_uking
yirring11307763y_irring
yodeling1357673yodeling
yodling123610253y_odling
yowling143610223y_owling
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.423422437.4
2DLD Change Limit1461625216.78021557.8
3Display Results5215210.2202368.2
 (SQL Overall)1786915217.42324072.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.