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

369 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
prawning144696(None) 
pawning134711411p_awning
awning105013392__awning
braining113414682braining
branning112911092branning
brawling143210042brawling
browning14299642browning
craning103620302cra_ning
crawling143110512crawling
crowning143510032crowning
dawning124111012_dawning
draining103312672draining
drawing123812052draw_ing
drawling13318672drawling
drowning13298362drowning
fawning14409132_fawning
frowning15307832frowning
graining102813182graining
paining103920242p_aining
panning104019392p_anning
parawing14310582paraw_ing
pawing124519552p_aw_ing
plaining113911552plaining
planing103418252pla_ning
planning113610222planning
praising113214562praising
prancing132612162prancing
pranging123012722pranging
pranking153813382pranking
prating103424452pra_ting
praying133717322pra_ying
preening113115842preening
prowling1449992prowling
pruning10311732pr_uning
raining83922692_raining
spawning14296912spawning
spraining1248152spraining
sprawling15175122sprawling
training93015862training
trawling122710782trawling
yawning14378342_yawning
aproning11311793apr_oning
aweing103911253__aweing
awing96827323__aw_ing
awnings11406713__awnings
baning95127833_ba_ning
banning103818233_banning
barning104320353_barning
bawling133813863_bawling
beaning103820683bea_ning
blawing134012753blaw_ing
bracing123817613bra_cing
bradding13268933bradding
bragging13359333bragging
braiding123112703braiding
brailing113514793brailing
braising113014563braising
braking143917713bra_king
branding122513683branding
brassing112612303brassing
braving133714613bra_ving
bravoing1445993bravoing
brawnier13216723brawnier
brawnily1644083brawnily
braying134416313bra_ying
brazening2185183brazening
brazing193715113bra_zing
brewing133411153brew_ing
brining103216473br_ining
browsing14319353browsing
caning94128623_ca_ning
canning103620133_canning
cawing124322613_caw_ing
chaining142810783chaining
chawing164813033chaw_ing
clawing133812673claw_ing
clowning14307253clowning
craaling112711353craaling
crabbing15287933crabbing
cracking174013903cracking
cradling122411453cradling
crafting143710173crafting
cramming15339433cramming
cramping153411853cramping
cranking154613073cranking
craping124018713cra_ping
crapping153911453crapping
crashing143512633crashing
crating103725203cra_ting
cravening1547553cravening
craving134015733cra_ving
crayoning1535243crayoning
crazing193914583cra_zing
crewing133212633crew_ing
crooning113112113crooning
crowding15247933crowding
crowing133814763crow_ing
damning114211633_damning
darning93817333_darning
dawing114819823_daw_ing
dawting123610673_dawting
deaning94020473dea_ning
downing123811673_downing
drabbing14286803drabbing
drafting13339403drafting
dragging12308103dragging
dramming14347563dramming
draping114213353dra_ping
dratting10389653dratting
drawings13386283draw_ings
draying123813843dra_ying
droning93013723dr_oning
drownding1564123drownding
drowsing13287773drowsing
earning83418213_earning
erasing8317963era_sing
fanning113615073_fanning
flawing143812563flaw_ing
fragging14329423fragging
framing133014793fra_ming
franking164310863franking
frapping16348103frapping
fraying143413433fra_ying
gaining94015663_gaining
gawking16398823_gawking
gawping14418463_gawping
gnawing12377903gnaw_ing
gowning12258833_gowning
grabbing14267313grabbing
gracing113216443gra_cing
grading103918713gra_ding
grafting13319623grafting
granting103514523granting
graphing1538533graphing
grasping12348833grasping
grassing103311973grassing
grating93923183gra_ting
graving123114563gra_ving
graying124115883gra_ying
grayling1338003grayling
grazing183514553gra_zing
greening103112533greening
grinning1037863grinning
groaning102410283groaning
groining102310633groining
growing123512473grow_ing
growling1348163growling
hawing134322353_haw_ing
hawking183711423_hawking
impawning1743423impawning
ironing82414013ir_oning
jawing174414963_jaw_ing
kraaling13186663kraaling
lawing104625283_law_ing
leaning83721203lea_ning
learning978553learning
loaning83614833loa_ning
manning103616383_manning
mawing124020803_maw_ing
meaning103918703mea_ning
moaning103714443moa_ning
orating83520323ora_ting
ordaining1145753ordaining
owning104110333__owning
pacing114522753p_a_cing
packing164420723p_acking
padding123412513p_adding
paging104020403p_a_ging
paiking143814813p_aiking
painting113614423p_ainting
pairing103716733p_airing
paling93530133p_a_ling
palling104024483p_alling
palming123914013p_alming
palping124112873p_alping
panging113319113p_anging
panini8314273p_a_nini
panino8315683p_a_nino
panting104025423p_anting
parading12313863parading
paragoning1445953paragoning
parawings1535823paraw_ings
parching164313053parching
pardoning1338763pardoning
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
patining11312303patining
patting103722343p_atting
pausing103912813p_ausing
paving124519743p_a_ving
paying123722163p_a_ying
peaching163613643peaching
peacing124117073pea_cing
peaking144317693pea_king
pealing104123203pea_ling
pearling11912013pearling
peening103318303p_eening
peining104619153p_eining
penning103616493p_enning
pertaining1347993pertaining
pharming16248143pharming
phasing133211673pha_sing
phoning13312053p_honing
phrasing1438013phra_sing
piaffing1733923piaffing
pining93726533p__ining
pinning103417853p_inning
pirating11314513pira_ting
placing123815283pla_cing
plaguing1236033plaguing
plaiting113113513plaiting
planking153513013planking
plannings12325453plannings
planting113515383planting
plashing143311063plashing
plating103823073pla_ting
platting114813033platting
playing133816093pla_ying
plowing133111723plow_ing
poaching163510833poaching
praline93019743pra_line
prang84820323pra___ng
prattling1246303prattling
prawn105312433praw__n_
prawned1346743prawn_ed
prawner1246803prawn_er
prawners1346003prawners
prawns11509023praw__ns
preaching172811163preaching
preacting142412533preacting
prearming14139223prearming
preeing103817673pr_eeing
prepping12309763prepping
pressing112516443pressing
prevuing1457253prevuing
prewarning16135193prewarning
preweaning1645633preweaning
prewiring1547893prewiring
preying133114553pr_eying
pricing123417343pr_icing
pricking173212603pricking
priding113317543pr_iding
prigging13299093prigging
prilling113413413prilling
priming123417373pr_iming
primming15268173primming
primping15338893primping
prinking153212453prinking
printing113216083printing
prising103321453pr_ising
prisoning1237643prisoning
prissing113011453prissing
prizing193514683pr_izing
probing123314443pr_obing
prodding13189343prodding
profaning1537293profaning
progging132610383progging
promoing13310463promoing
pronging123511843pronging
proofing1439313proofing
propining14310133propining
proponing1439993proponing
propping122811673propping
prosing103319383pr_osing
proving134214073pr_oving
prying124114803pr__ying
psalming1375473psalming
pshawing1733523pshaw_ing
punning103414993p_unning
racing95030533_ra_cing
racking144323663_racking
radding103715003_radding
rafting113815753_rafting
ragging103516683_ragging
raging85126433_ra_ging
raiding93617593_raiding
railing83325643_railing
raising83220533_raising
raking114728423_ra_king
ramming123115063_ramming
ramping123316873_ramping
ranging94120263_ranging
ranking124320883_ranking
ranting84025413_ranting
raping94829853_ra_ping
rapping123619103_rapping
raring74332873_ra_ring
rasing74330833_ra_sing
rasping104316253_rasping
rating74938703_ra_ting
ratting83822363_ratting
ravening122611293_ravening
raving105128853_ra_ving
ravining12269693_ravining
rawin85521473_raw_in_
rawins95617623_raw_ins
raxing144321023_ra_xing
raying105027193_ra_ying
razing164524543_ra_zing
razzing1636323_razzing
reining84425323_reining
rinning83216743_rinning
rowing103623303_row_ing
ruining83514883_ruining
running83514593_running
saining83621393_saining
saning75127643_sa_ning
sawing104323813_saw_ing
scanning113310773scanning
scrawling15195583scrawling
shawing143514883shaw_ing
shawling1558223shawling
snawing113612483snaw_ing
spanning113311083spanning
speaning113512243spea_ning
spraying14299883spra_ying
staining9413373staining
staning83922243sta_ning
straining10410563straining
strawing122411623straw_ing
swanning12338813swanning
tanning83618253_tanning
tawing104521553_taw_ing
tawsing1138673_tawsing
thawing14378683thaw_ing
thrawing1535963thraw_ing
tracing103720153tra_cing
tracking153715463tracking
trading93517973tra_ding
traiking132511973traiking
trailing92916093trailing
trainings10246723trainings
tramming13279343tramming
tramping132711273tramping
trancing112812023trancing
trapping132911393trapping
trashing122613223trashing
trining82919213tr_ining
trowing113413703trow_ing
unwaning1238133unwaning
upraising1237263upraising
uprating11311113upra_ting
vanning113912463_vanning
waning103623803_wa_ning
wanning113816213_wanning
warning113717093_warning
wawling143810963_wawling
weaning114117193wea_ning
wracking18349963wracking
wrapping16297623wrapping
wrathing15248923wrathing
yarning113512953_yarning
yawing134215613_yaw_ing
yawling14369183_yawling
yawping16357333_yawping
yeaning113814633yea_ning
yearning1296983yearning

Search took 9 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 Limit1461623698.04618165.8
3Display Results3693690.1432580.4
 (SQL Overall)1786913698.62520717.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.