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

391 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
glancing124706(None) 
lancing103314121_lancing
balancing1435782balancing
blanching17297092blanching
blanking154411932blanking
chancing162810282chancing
clanging124012122clanging
clanking154313062clanking
dancing113611562_dancing
flanging132710582flanging
flanking164211082flanking
ganging103216192g_anging
glaceing1236532glaceing
gladding1236302gladding
glairing1047282glairing
glancingly1742872glancingly
glaring93714882gla_ring
glassing10329972glassing
glazing183611002gla_zing
gleaning10269322glean_ing
glinting103210052glinting
glunching16174082glunching
gracing113216442gra_cing
granting103514522granting
lacing94626232_la_cing
landing92819322_landing
placing123815282pla_cing
planing103418252plan_ing
planking153513012planking
planning113610222planning
planting113515382planting
prancing132612162prancing
slanging103413432slanging
slanting94115092slanting
trancing112812022trancing
valancing1544742valancing
acing87429153__a_cing
advancing1643063advancing
alanin6317273alan_in_
alanine7316863alan_ine
alanins7315803alan_ins
alarming1138583alarming
alining81917043alin_ing
anting75827023__anting
arcing95819643__arcing
banding114921413_banding
banging114019863_banging
baning95127833_ban_ing
banking144621353_banking
banning103818233_banning
beaning103820683bean_ing
blabbing12266723blabbing
blacking174213603blacking
blading113615363bla_ding
blagging13319163blagging
blaming123515693bla_ming
blaring104317113bla_ring
blasting114013423blasting
blatting114111653blatting
blawing134012753bla_wing
blazing193612393bla_zing
blenching17276503blenching
blending12249963blending
blinding123210163blinding
blinking153510623blinking
blunging12328413blunging
blunting11319843blunting
bouncing13318773bouncing
bracing123817613bra_cing
branching17289263branching
branding122513683branding
branning112911093branning
caning94128623_can_ing
canning103620133_canning
canting104725903_canting
changing153211513changing
chanting143413533chanting
clacking173313493clacking
cladding1337143cladding
clagging13328873clagging
claiming13279303claiming
clamming15329373clamming
clamping154011153clamping
clapping153810603clapping
clashing143812193clashing
clasping133310263clasping
classing113211793classing
clawing133812673cla_wing
claying133614303cla_ying
cleaning113112383clean_ing
cleansing1235073cleansing
clenching17266303clenching
clinching17276123clinching
clinging122910913clinging
clinking153611663clinking
cloning103215473clon_ing
clonking153810153clonking
clunking15329433clunking
cranching17278733cranching
craning103620303cran_ing
cranking154613073cranking
danging103716093_danging
deaning94020473dean_ing
eanling81416673_eanling
eglantine1044973eglantine
elapsing1146713elapsing
elating83423083ela_ting
enhancing1545823enhancing
enlacing1148773enla_cing
evincing1446183evincing
facing125321573_fa_cing
fancying1735353_fancying
fanning113615073_fanning
farcing133514003_farcing
fencing132411133_fencing
financing1544073financing
flacking184311793flacking
flagging14329223flagging
flailing12298923flailing
flaking154114493fla_king
flaming134216443fla_ming
flamming16357153flamming
flapping16298153flapping
flaring114116803fla_ring
flashing153711553flashing
flatling123410013flatling
flatting123511253flatting
flaunting1335043flaunting
flawing143812563fla_wing
flaying143914463fla_ying
fleecing14347573fleecing
flenching18296703flenching
flensing1246973flensing
flinching18245833flinching
flinging133310053flinging
flinting123412343flinting
floccing16306033floccing
flouncing1533903flouncing
flunking16317773flunking
franking164310863franking
gabbing133512033g_abbing
gabling113514543g_abling
gadding113411453g_adding
gaeing84617223g_a_eing
gaffing15379733g_affing
gagging93013523g_agging
gaging94718403g_a_ging
gaining94015663g_aining
gaiting93716583g_aiting
galantine1047313galantine
gallanting1245343gallanting
galling93921963g_alling
gallying13328933gallying
galoping1258023galoping
gaming104622043g_a_ming
gamming133112623g_amming
gangling112411403g_angling
gaoling93314653g_aoling
gaping105618923g_a_ping
gapping134214783g_apping
garbing113613273g_arbing
garlanding1344433garlanding
garring93116713g_arring
gashing125119233g_ashing
gasking134415913g_asking
gasping113714363g_asping
gassing94216333g_assing
gasting95022763g_asting
gating84826953g_a_ting
gauging10339963g_auging
gauming11319713g_auming
gawking16398823g_awking
gawping14418463g_awping
gazing174717173g_a_zing
gearing92818843gea_ring
gelating103015733gela_ting
ginning93313983g_inning
girning93210693girn_ing
glacial1038143gla_cial
glacier103911293gla_cier
glacis94012133gla_ci_s
glance94312313glanc__e
glanced11439233glanc_ed
glancer103710073glanc_er
glancers11408003glancers
glances104113143glanc_es
glassine9329313glassine
glazings19325753gla_zings
gleaming12277933gleaming
gleanings11244643glean_ings
gleeking14316493gleeking
gleeting10279173gleeting
gleying12318433gl_eying
gliding103911843gl_iding
gliming113310133gl_iming
glitzing1934973glitzing
gloaming12268013gloaming
gloating102611463gloating
globing113210003gl_obing
glomming14275923glomming
glonoin875673glonoin_
glonoins955843glonoins
glooming12358013glooming
glopping14307753glopping
glorying1335543glorying
glossing10278883glossing
glouting10379693glouting
gloving12308443gl_oving
glowing123211793gl_owing
glozing18338893gl_ozing
glueing9338713gl_ueing
glugging10316353glugging
gluing83812053gl__uing
glutting10247643glutting
glycin1235963gl_ycin_
glycine1335713gl_ycine
glycins1335563gl_ycins
gnarling10217603gnarling
gnarring10225973gnarring
gnashing1336423gnashing
gnawing12377903gna_wing
goading103112853goa_ding
goaling93515333goa_ling
gonging103713033g_onging
gowning12258833gown_ing
grabbing14267313grabbing
grading103918713gra_ding
grafting13319623grafting
graining102813183graining
graphing1538533graphing
grasping12348833grasping
grassing103311973grassing
grating93923183gra_ting
graving123114563gra_ving
graying124115883gra_ying
grayling1338003grayling
grazing183514553gra_zing
grinding1139863grinding
grinning1037863grinning
groaning102410283groan_ing
grunting10269583grunting
guanin7610803guan_in_
guanine8810543guan_ine
guanins8810013guan_ins
guarding1136523guarding
gunning93413173g_unning
handing123518893_handing
hanging123518703_hanging
hanking154619103_hanking
hanting114124483_hanting
inlacing1158373inla_cing
islanding1135623islanding
jauncing18314783jauncing
jouncing18336853jouncing
lacings105013653_la_cings
lacking143821543_lacking
lading84227123_la_ding
ladling92813393_ladling
lagging103316733_lagging
lairing83715343_lairing
laking115027043_la_king
lalling83519623_lalling
lambing123412403_lambing
laming94528363_la_ming
lamming123014583_lamming
lamping123116003_lamping
landings103110073_landings
lapping124117023_lapping
lapsing103511163_lapsing
lapwing13308263_lapwing
larding92917873_larding
larking123718253_larking
lashing114422893_lashing
lasing74727983_la_sing
lasting84725243_lasting
latching143712023_latching
lathing114315693_lathing
lauding93211903_lauding
launching1544783_launching
laving104623573_la_ving
lawing104625283_la_wing
laying104525703_la_ying
lazing164821473_la_zing
lazying2046673_lazying
leaning83721203lean_ing
lending94118533_lending
lensing84015103_lensing
lining74526803_lin_ing
linking123818253_linking
linting83820983_linting
loaning83614833loan_ing
longing93915783_longing
lunching143110003_lunching
lunging93714213_lunging
lunting83817743_lunting
lynching17336083_lynching
macing114221553_ma_cing
manning103616383_manning
meaning103918693mean_ing
menacing1339773menacing
mincing123314333_mincing
moaning103714443moan_ing
pacing114522753_pa_cing
panging113319113_panging
panning104019393_panning
panting104025423_panting
peacing124117073pea_cing
penancing1436343penancing
plaguing1236033plaguing
plaining113911553plaining
plaiting113113513plaiting
plankings16326113plankings
plannings12325453plannings
plantings12348403plantings
plashing143311063plashing
plating103823073pla_ting
platting114813033platting
playing133816093pla_ying
plinking153611243plinking
plonking15358563plonking
plunging12357673plunging
plunking15328483plunking
poncing122913583_poncing
pouncing13318883pouncing
pranging123012723pranging
pranking153813383pranking
quanting1849233quanting
racing95030533_ra_cing
ranching141712043_ranching
ranging94120263_ranging
ranking124320883_ranking
ranting84025413_ranting
relacing112516043rela_cing
relanding112110923relanding
romancing1446043romancing
sanding93520603_sanding
saning75127643_san_ing
saucing10311003_saucing
scanning113310773scanning
scanting113914763scanting
sconcing1338263sconcing
shanking163612283shanking
silencing1245053silencing
skanking12288743skanking
slabbing13287783slabbing
slacking153914133slacking
slagging113711573slagging
slaking123717473sla_king
slamming133310003slamming
slapping133510833slapping
slashing123713413slashing
slating83724653sla_ting
slatting94014233slatting
slaving113514833sla_ving
slaying113316843sla_ying
slicing103514643sl_icing
slinging103312863slinging
slinking133412983slinking
sluicing1137063sluicing
solacing11310133sola_cing
spacing123614493spa_cing
spanking153911973spanking
spanning113311083spanning
stanching1538083stanching
standing103413633standing
stanging104013653stanging
staning83922243stan_ing
swanking16399963swanking
swanning12338813swanning
syncing13177223_syncing
talcing103111633_talcing
tanging93419523_tanging
tanking123918793_tanking
tanning83618253_tanning
thanking16409523thanking
tracing103720153tra_cing
twanging13287063twanging
unlacing1148643unla_cing
vanning113912463_vanning
waning103623803_wan_ing
wanking154216783_wanking
wanning113816213_wanning
wanting114220173_wanting
weaning114117193wean_ing
weanling12118643weanling
whanging16267143whanging
wincing133413903_wincing
yanking154512463_yanking
yeaning113814633yean_ing
yeanling12107063yeanling
zincing192910283_zincing

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.1701051123.5
2DLD Change Limit1461623917.19020328.5
3Display Results3913910.1702300.0
 (SQL Overall)1786913917.53023730.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.