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

444 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
prancing13261216(None) 
pranging123012721pranging
pranking153813381pranking
trancing112812021trancing
bracing123817612bra_cing
branching17289262branching
branding122513682branding
branning112911092branning
chancing162810282chancing
cranching17278732cranching
craning103620302cran_ing
cranking154613072cranking
dancing113611562_dancing
franking164310862franking
glancing1247062glancing
gracing113216442gra_cing
granting103514522granting
lancing103314122_lancing
pacing114522752p_a_cing
panging113319112p_anging
panning104019392p_anning
panting104025422p_anting
peacing124117072pea_cing
penancing1436342penancing
placing123815282pla_cing
planing103418252plan_ing
planking153513012planking
planning113610222planning
planting113515382planting
poncing122913582p_oncing
pouncing13318882pouncing
praising113214562praising
prating103424452pra_ting
prawning1446962prawning
praying133717322pra_ying
pricing123417342pr_icing
prinking153212452prinking
printing113216082printing
pronging123511842pronging
pruning10311732prun_ing
racing95030532_ra_cing
ranching141712042_ranching
ranging94120262_ranging
ranking124320882_ranking
ranting84025412_ranting
tracing103720152tra_cing
acing87429153__a_cing
advancing1643063advancing
anting75827023__anting
aproning11311793apron_ing
arcing95819643__arcing
arranging1156303arranging
balancing1435783balancing
banding114921413_banding
banging114019863_banging
baning95127833_ban_ing
banking144621353_banking
banning103818233_banning
barning104320353barn_ing
beaning103820683bean_ing
blanching17297093blanching
blanking154411933blanking
bouncing13318773bouncing
bracings13369293bra_cings
bradding13268933bradding
bragging13359333bragging
braiding123112703braiding
brailing113514793brailing
braining113414683braining
braising113014563braising
braking143917713bra_king
brandings13277483brandings
brandling1348253brandling
brandying1654883brandying
brassing112612303brassing
braving133714613bra_ving
bravoing1445993bravoing
brawling143210043brawling
braying134416313bra_ying
brazing193715113bra_zing
bringing123011273bringing
brining103216473brin_ing
bronzing2037693bronzing
brunching17316483brunching
caning94128623_can_ing
canning103620133_canning
canting104725903_canting
changing153211513changing
chanting143413533chanting
clanging124012123clanging
clanking154313063clanking
craaling112711353craaling
crabbing15287933crabbing
cracking174013903cracking
cradling122411453cradling
crafting143710173crafting
cramming15339433cramming
cramping153411853cramping
crankling16147293crankling
craping124018713cra_ping
crapping153911453crapping
crashing143512633crashing
crating103725203cra_ting
craunching1843313craunching
craving134015733cra_ving
crawling143110513crawling
crazing193914583cra_zing
cringing123311383cringing
crunching17297003crunching
danging103716093_danging
darning93817333darn_ing
deaning94020473dean_ing
deranging1238063deranging
drabbing14286803drabbing
drafting13339403drafting
dragging12308103dragging
draining103312673draining
dramming14347563dramming
draping114213353dra_ping
dratting10389653dratting
drawing123812053dra_wing
drawling13318673drawling
draying123813843dra_ying
drenching16256033drenching
drinking14308913drinking
droning93013723dron_ing
eanling81416673_eanling
earning83418213earn_ing
enhancing1545823enhancing
entrancing1346783entrancing
erasing8317963era_sing
evincing1446183evincing
facing125321573_fa_cing
fancying1735353_fancying
fanning113615073_fanning
farcing133514003_farcing
fencing132411133_fencing
financing1544073financing
flanging132710583flanging
flanking164211083flanking
fragging14329423fragging
framing133014793fra_ming
francium1545623francium
francize2246853francize
francizing2545373francizing
frapping16348103frapping
fraying143413433fra_ying
frenching18267753frenching
fringing133010903fringing
fronting12310443fronting
frouncing1534763frouncing
furnacing1543713furnacing
ganging103216193_ganging
grabbing14267313grabbing
grading103918713gra_ding
grafting13319623grafting
graining102813183graining
graphing1538533graphing
grasping12348833grasping
grassing103311973grassing
grating93923183gra_ting
graving123114563gra_ving
graying124115883gra_ying
grayling1338003grayling
grazing183514553gra_zing
grinding1139863grinding
grinning1037863grinning
groaning102410283groan_ing
grunting10269583grunting
handing123518893_handing
hanging123518703_hanging
hanking154619103_hanking
hanting114124483_hanting
ironing82414013iron_ing
jauncing18314783jauncing
jouncing18336853jouncing
kraaling13186663kraaling
lacing94626233_la_cing
landing92819323_landing
leaning83721203lean_ing
loaning83614833loan_ing
macing114221553_ma_cing
manning103616383_manning
meaning103918703mean_ing
menacing1339783menacing
mincing123314333_mincing
moaning103714443moan_ing
orating83520323ora_ting
packing164420723p_acking
padding123412513p_adding
paging104020403p_a_ging
paiking143814813p_aiking
paining103920243p_aining
painting113614423painting
pairing103716733p_airing
paling93530133p_a_ling
palling104024483p_alling
palming123914013p_alming
palping124112873p_alping
pancaking1836383p_ancaking
pandying15217663p_andying
paneling111013623p_aneling
panicking1835293p_anicking
panini8314273p_an_ini
panino8315683p_an_ino
parading12313863parading
parawing14310583parawing
parching164313053parching
parenting12611583parenting
parging113318603p_arging
paring94236493p_a_ring
parking143423043p_arking
parling103823763p_arling
paroling113316213paroling
parring103222063p_arring
parrying14168133parrying
parsing103819553p_arsing
parting103527383p_arting
partying14168893partying
pashing135120513p_ashing
passing104318423p_assing
pasting103826553p_asting
patching163212753p_atching
patting103722343p_atting
pausing103912813p_ausing
paving124519743p_a_ving
pawing124519553p_a_wing
pawning134711413p_awning
paying123722163p_a_ying
peaching163613643peaching
peaking144317693pea_king
pealing104123203pea_ling
pearling11912013pearling
peening103318303peen_ing
peining104619153pein_ing
pending114119773p_ending
penning103616493p_enning
pharming16248143pharming
phasing133211673pha_sing
phoning13312053phon_ing
phonying1745833phonying
phrasing1438013phra_sing
piaffing1733923piaffing
piecing12410453p_iecing
piercing1346663piercing
pinching163711053p_inching
pinging113419553p_inging
pining93726533p_in_ing
pinking143918943p_inking
pinning103417853p_inning
pirating11314513pira_ting
plaguing1236033plaguing
plaining113911553plaining
plaiting113113513plaiting
plankings16326113plankings
plannings12325453plannings
plantings12348403plantings
plashing143311063plashing
plating103823073pla_ting
platting114813033platting
playing133816093pla_ying
plinking153611243plinking
plonking15358563plonking
plunging12357673plunging
plunking15328483plunking
poaching163510833poaching
poinding122510003poinding
pointing112813683pointing
policing13311673policing
ponding114317083p_onding
ponging113416153p_onging
ponying133312123p_onying
pounding123311473pounding
practicing1775583practicing
praecipe1444633praecipe
praline93019743pra_line
prance104318573pranc__e
pranced123714043pranc_ed
prancer113613383pranc_er
prancers123210333prancers
prances113618773pranc_es
prandial1149643prandial
prang84820323pra___ng
prankish1737023prankish
prattling1246303prattling
preaching172811163preaching
preacting142412533preacting
prearming14139223prearming
preeing103817673pr_eeing
preening113115843preening
prefacing17118743prefacing
prenticing1547883prenticing
prepping12309763prepping
prescind1338393prescind
pressing112516443pressing
prevuing1457253prevuing
preying133114553pr_eying
pricking173212603pricking
priding113317543pr_iding
prigging13299093prigging
prilling113413413prilling
priming123417373pr_iming
primming15268173primming
primping15338893primping
princeling1544653princeling
principe1445683principe
principi1443933principi
printings12268103printings
prising103321453pr_ising
prissing113011453prissing
prizing193514683pr_izing
probing123314443pr_obing
prodding13189343prodding
producing1556143producing
profaning1537293profan_ing
progging132610383progging
promoing13310463promoing
pronating12313763pronating
proofing1439313proofing
propping122811673propping
prosing103319383pr_osing
proving134214073pr_oving
prowling1449993prowling
prying124114803pr__ying
psalming1375473psalming
pumicing1535843pumicing
punching163310123p_unching
punning103414993p_unning
punting103318443p_unting
quanting1849233quanting
racings105015133_ra_cings
racking144323663_racking
radding103715003_radding
rafting113815753_rafting
ragging103516683_ragging
raging85126433_ra_ging
raiding93617593_raiding
railing83325643_railing
raining83922693_raining
raising83220533_raising
raking114728423_ra_king
ramming123115063_ramming
ramping123316873_ramping
rancid9513863_ranci_d
rankings13389173_rankings
rankling132610113_rankling
raping94829853_ra_ping
rapping123619103_rapping
raring74332873_ra_ring
rasing74330833_ra_sing
rasping104316253_rasping
rating74938703_ra_ting
ratting83822363_ratting
raving105128853_ra_ving
raxing144321023_ra_xing
raying105027193_ra_ying
razing164524543_ra_zing
razzing1636323_razzing
rending93924263_rending
renting84026853_renting
ricing94822763_r_icing
ringing93521283_ringing
rinning83216743_rinning
rinsing82516113_rinsing
romancing1446043romancing
running83514593_running
sanding93520603_sanding
saning75127643_san_ing
saucing10311003_saucing
scanning113310773scanning
scanting113914763scanting
sconcing1338263sconcing
shanking163612283shanking
skanking12288743skanking
slanging103413433slanging
slanting94115093slanting
spacing123614493spa_cing
spanking153911973spanking
spanning113311083spanning
speaning113512243spean_ing
spraining1248153spraining
sprawling15175123sprawling
spraying14299883spra_ying
springing1338743springing
sprinting12310033sprinting
sprucing1336893spr_ucing
stanching1538083stanching
standing103413633standing
stanging104013653stanging
staning83922243stan_ing
stranding1149653stranding
swanking16399963swanking
swanning12338813swanning
syncing13177223_syncing
talcing103111633_talcing
tanging93419523_tanging
tanking123918793_tanking
tanning83618253_tanning
thanking16409523thanking
tracings112910413tra_cings
tracking153715463tracking
trading93517973tra_ding
traducing1374013traducing
traiking132511973traiking
trailing92916093trailing
training93015863training
tramming13279343tramming
tramping132711273tramping
trapping132911393trapping
trashing122613223trashing
trawling122710783trawling
trenching15227653trenching
trending103012833trending
tricing103417353tr_icing
trining82919213trin_ing
trouncing1235153trouncing
truanting1035603truanting
trucing103211843tr_ucing
twanging13287063twanging
upraising1237263upraising
uprating11311113upra_ting
valancing1544743valancing
vanning113912463_vanning
waning103623803_wan_ing
wanking154216783_wanking
wanning113816213_wanning
wanting114220173_wanting
warning113717093warn_ing
weaning114117193wean_ing
weanling12118643weanling
whanging16267143whanging
wincing133413903_wincing
wracking18349963wracking
wrangling1456223wrangling
wrapping16297623wrapping
wrathing15248923wrathing
wrenching18276273wrenching
wringing13279623wringing
wronging13327393wronging
yanking154512463_yanking
yarning113512953yarn_ing
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.436409841.7
2DLD Change Limit1461624446.94021060.8
3Display Results4444440.1702611.8
 (SQL Overall)1786914447.54623680.2
 
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.