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

399 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
alarming113858(None) 
alaruming1243711alaruming
alarmingly1643242alarmingly
alarmism1245852alarmism
alarmist1049122alarmist
alerting91312382alerting
arming94719802__arming
awarding1356042awarding
blaming123515692bla_ming
blaring104317112blar_ing
charming163012032charming
claiming13279302claiming
clamming15329372clamming
farming133515082_farming
flaming134216442fla_ming
flamming16357152flamming
flaring114116802flar_ing
glaring93714882glar_ing
harming133717932_harming
inarming1138342inarming
laming94528362_la_ming
lamming123014582_lamming
larding92917872_larding
larking123718252_larking
pharming16248142pharming
rearming111413612rearming
salaaming1265362salaaming
salarying1336072salarying
slamming133310002slamming
swarming1458222swarming
unarming1138622unarming
warming133515082_warming
aahing1019015763a_a_hing
abashing1466623abashing
abasing10610673aba_sing
abating10413973aba_ting
ablating11311993abla_ting
aborning1188003aborning
aborting11710253aborting
abrading1239503abrading
acarine9316003acar_ine
acclaiming1743633acclaiming
accruing1344033accruing
adapting1236643adapting
adeeming1254793adeeming
adoring9412523ador_ing
adorning1087323adorning
aerating92821003aerating
affirming1843103affirming
aiming94320843__aiming
airing74927503a_ir_ing
airting83616303a_irting
alang66023513ala___ng
alanin6317273ala_nin_
alanine7316863ala_nine
alanins7315803ala_nins
alarm76621423alarm___
alarmed1037733alarm_ed
alarmisms1345003alarmisms
alarmists1145943alarmists
alarms85913053alarm__s
albumin1145563albumin_
albumins1245353albumins
aldrin7311243aldr_in_
aldrins8310203aldr_ins
aliasing9310073aliasing
alibiing1135323alibiing
aliening91510893aliening
aligning10158533aligning
alining81917043al_ining
allaying12339303allaying
alleging1038473alleging
allowing12369093allowing
alloying12339143alloying
alluding1036953alluding
alluring939073alluring
allying113011663al_lying
altering91917113altering
alumin8513543al_umin_
alumina9510053al_umina
alumine9412693al_umine
alumins9512983al_umins
amassing1138003amassing
amazing1938813ama_zing
amercing1337193amercing
anearing9413973anear_ing
arcing95819643__arcing
armings103811503__armings
arraying1238753arraying
ashlaring1344493ashlar_ing
assuming1135143assuming
availing1267283availing
averring12239063averring
averting122512733averting
awaiting1238273awaiting
awaking1547813awa_king
balancing1435783balancing
balsaming1445123balsaming
bamming144611813_bamming
barbing123716993_barbing
barding113822893_barding
barfing134615093_barfing
barging114018483_barging
baring95135853_bar_ing
barking144724183_barking
barning104320353_barning
barring104021593_barring
beaming123618803bea_ming
bearding124011943bearding
bearing103624773bear_ing
berming123614833_berming
blabbing12266723blabbing
blacking174213603blacking
blading113615363bla_ding
blagging13319163blagging
blanking154411933blanking
blasting114013423blasting
blatting114111653blatting
blawing134012753bla_wing
blazing193612393bla_zing
blearing113111943blear_ing
blooming13299433blooming
bluming123511283bl_uming
blurbing13326503blurbing
blurring11277233blurring
blurting11258773blurting
boarding123110233boarding
calamine12314033cala_mine
calamint12315133cala_mint
calming123915973_calming
carding113922433_carding
caring95137993_car_ing
carking144322853_carking
carling103727063_carling
carmine112918483_carmine
caroming133312963_caroming
carping123521083_carping
carting104228283_carting
carving133916773_carving
charging152910773charging
charing133721323char_ing
charking183512613charking
charring142913163charring
charting142614193charting
chirming16318643chirming
clacking173313493clacking
cladding1337143cladding
clagging13328873clagging
clamping154011153clamping
clanging124012123clanging
clanking154313063clanking
clapping153810603clapping
clashing143812193clashing
clasping133310263clasping
classing113211793classing
clawing133812673cla_wing
claying133614303cla_ying
clearing113014883clear_ing
clearwing1533673clearwing
clerking15257163clerking
coaming123818323coa_ming
cramming15339433cramming
damming133812743_damming
daring84928683_dar_ing
darking134217343_darking
darling93418363_darling
darning93817333_darning
darting94020663_darting
disarming1338803disarming
dramming14347563dramming
dwarfing1633613dwarfing
earing75235483_ear_ing
earning83418213_earning
earring83519013_earring
elapsing1146713elapsing
elating83423083ela_ting
enlarging1135803enlarging
faming124922973_fa_ming
farcing133514003_farcing
farding123716743_farding
faring105231283_far_ing
farmings14298223_farmings
farting114120753_farting
fearing113520033fear_ing
firming132811223_firming
flacking184311793flacking
flagging14329223flagging
flailing12298923flailing
flaking154114493fla_king
flamingo14274143fla_mingo
flanging132710583flanging
flanking164211083flanking
flapping16298153flapping
flashing153711553flashing
flatling123410013flatling
flatting123511253flatting
flawing143812563fla_wing
flaying143914463fla_ying
flirting12319013flirting
fluming133512793fl_uming
foaming133612993foa_ming
forming133615733_forming
framing133014793fra_ming
gaming104622043_ga_ming
gamming133112623_gamming
garbing113613273_garbing
garring93116713_garring
gauming11319713_gauming
gearing92818843gear_ing
glaceing1236533glaceing
gladding1236303gladding
glairing1047283glairing
glancing1247063glancing
glassing10329973glassing
glazing183611003gla_zing
gleaming12277933gleaming
gliming113310133gl_iming
gloaming12268013gloaming
glomming14275923glomming
glooming12358013glooming
glorying1335543glorying
gnarling10217603gnarling
gnarring10225973gnarring
gorming112810833_gorming
guarding1136523guarding
hamming153014093_hamming
haring104233003_har_ing
harking154120943_harking
harmin113117393_harmin_
harmine122816193_harmine
harmins123716723_harmins
harping134118383_harping
hazarding2343403hazarding
hearing113324163hear_ing
hearsing1239383hearsing
hearting12513123hearting
hoarding13288643hoarding
illuming1135873illuming
jamming19329793_jamming
jarring153613193_jarring
karting123716063_karting
lacing94626233_la_cing
lacking143821543_lacking
lading84227123_la_ding
ladling92813393_ladling
lagging103316733_lagging
lairing83715343_lairing
laking115027043_la_king
lalling83519623_lalling
lambing123412413_lambing
lamina84920443_la_mina
lamping123116003_lamping
lancing103314123_lancing
landing92819323_landing
lapping124117023_lapping
lapsing103511163_lapsing
lapwing13308263_lapwing
larine63927043_lar_ine
lashing114422893_lashing
lasing74727983_la_sing
lasting84725243_lasting
lathing114315693_lathing
lauding93211903_lauding
laving104623573_la_ving
lawing104625283_la_wing
laying104525703_la_ying
lazing164821473_la_zing
lazying2046673_lazying
learning978553learning
lemming12269393_lemming
liming94021243_l_iming
loaming103613733_loaming
looming102814853_looming
lording93115233_lording
luring73820753_lur_ing
lurking123710853_lurking
maiming122912723_maiming
marking144020133_marking
marling103322763_marling
marring103319553_marring
marting103325013_marting
naming93917893_na_ming
napalming1443173napalming
narking124015383_narking
nearing83020333near_ing
oaring74225303_oar_ing
palming123914013_palming
parging113318603_parging
paring94236493_par_ing
parking143423043_parking
parling103823763_parling
parring103222063_parring
parsing103819553_parsing
parting103527383_parting
pearling11912013pearling
perming123416093_perming
pharmings17254723pharmings
placing123815283pla_cing
plaguing1236033plaguing
plaining113911553plaining
plaiting113113513plaiting
planing103418253pla_ning
planking153513013planking
planning113610223planning
planting113515383planting
plashing143311063plashing
plasmin112410033plasmin_
plasmins12199403plasmins
plating103823073pla_ting
platting114813033platting
playing133816093pla_ying
pluming123412043pl_uming
prearming14139223prearming
psalming1375473psalming
ramming123115063_ramming
raring74332873_rar_ing
reaming103924013rea_ming
rearing83128783rear_ing
rewarming15147383rewarming
roaming103215793roa_ming
roaring82916003roar_ing
safariing1344553safariing
scamming15328543scamming
scarfing14309713scarfing
scaring103421973scar_ing
scarping133312463scarping
scarring112511513scarring
scarting113415263scarting
seaming103222113sea_ming
searing83330923sear_ing
shaming133016743sha_ming
shamming16289413shamming
sharing113723243shar_ing
sharking163912973sharking
sharping143011373sharping
slabbing13287783slabbing
slacking153914133slacking
slagging113711573slagging
slaking123717473sla_king
slaloming1244743slaloming
slammings14234123slammings
slanging103413433slanging
slanting94115093slanting
slapping133510833slapping
slashing123713413slashing
slating83724653sla_ting
slatting94014233slatting
slaving113514833sla_ving
slaying113316843sla_ying
sliming102913953sl_iming
slimming13288093slimming
slumming13278383slumming
slurping11278123slurping
slurring9288833slurring
smarting113212453smarting
snarfing12358663snarfing
snaring83920953snar_ing
snarling92513183snarling
soaring83521893soar_ing
spamming15317603spamming
sparging122611133sparging
sparing104823873spar_ing
sparking152812543sparking
sparling112714533sparling
sparring113112223sparring
spasming13227203spasming
staring84527053star_ing
starling93017123starling
starring92312953starring
starting93116173starting
starving122510173starving
storming11209423storming
swarding1359003swarding
taming94023433_ta_ming
taring73932283_tar_ing
tarring83318303_tarring
tarting84222653_tarting
teaming103917593tea_ming
tearing84021493tear_ing
terming104016003_terming
tramming13279343tramming
valancing1544743valancing
varmint12311683_varmint
varying1429723_varying
warding123918143_warding
waring105029443_war_ing
warking153519573_warking
warning113717093_warning
warping133715183_warping
warring113717973_warring
wearing113318863wear_ing
wearying1546703wearying
whamming19275223whamming
wharfing1834683wharfing
worming132811243_worming
yarding123413143_yarding
yarning113512953_yarning
yearling1297883yearling
yearning1296983yearning

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 Limit1461623997.03320782.3
3Display Results3993990.1562557.7
 (SQL Overall)1786913997.34524328.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.