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

417 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
prowling144999(None) 
growling1348161growling
bowling133916492_bowling
brawling143210042brawling
broiling113112012broiling
browning14299642browning
browsing14319352browsing
cowling134017422_cowling
crawling143110512crawling
crowding15247932crowding
crowing133814762crow_ing
crowning143510032crowning
drawling13318672drawling
drolling103510762drolling
drooling102610422drooling
drowning13298362drowning
drowsing13287772drowsing
fowling143713112_fowling
frowning15307832frowning
growing123512472grow_ing
howling143413162_howling
paroling113316212paro_ling
peopling1338352peopling
plowing133111722plow_ing
poling93526502p_o_ling
polling102920382p_olling
pooling103219092p_ooling
prawning1446962prawning
prilling113413412prilling
probing123314442pro_bing
prodding13189342prodding
profiling1548232profiling
progging132610382progging
proline92321592pro_line
prolong10319632pro_long
promoing13310462promoing
pronging123511842pronging
proofing1439312proofing
propping122811672propping
prosing103319382pro_sing
proving134214072pro_ving
roiling83220452_roiling
rolling83620412_rolling
roweling122811122_roweling
rowing103623302_row_ing
scowling1458292scowling
sprawling15175122sprawling
trawling122710782trawling
trolling93212492trolling
troweling1376362troweling
trowing113413702trow_ing
yowling143610222_yowling
aproning11311793apro_ning
argling92812733ar_gling
arousing93811803arousing
arrowing1237943arrow_ing
avowing1466603avow_ing
bawling133813863_bawling
behowling1843683behowling
blowing133813053blow_ing
boiling103819673_boiling
bolling103820883_bolling
boodling121910243boodling
boweling143410683_boweling
bowing124723063_bow_ing
bowline123613113_bowline
bowlings14408753_bowlings
bowsing134012503_bowsing
brailing113514793brailing
brewing133411153brew_ing
bridling122610583bridling
brisling112410843brisling
broking143514823bro_king
bronzing2037693bronzing
brooding122911373brooding
brooking153710703brooking
brooming132911143brooming
caroling113317003caro_ling
carolling1259413carolling
chowing164412773chow_ing
chowsing17217343chowsing
clowning14307253clowning
coaling103722823_coaling
codling114418953_codling
coiling103723453_coiling
cooling103422573_cooling
cowing124526323_cow_ing
cowlings14359783_cowlings
craaling112711353craaling
cradling122411453cradling
creeling113513363creeling
crewing133212633crew_ing
croaking153712163croaking
crocking174313443crocking
crooking153611343crooking
crooning113112113crooning
cropping153210883cropping
crossing112612683crossing
doling84923133_do_ling
dolling93817373_dolling
doodling11218403doodling
doweling13279763_doweling
dowing114221513_dow_ing
downing123811673_downing
dowsing123411123_dowsing
drawing123812053draw_ing
drilling103311983drilling
droning93013723dro_ning
drooping12268803drooping
dropping14309283dropping
drouking1436443drouking
droving12379683dro_ving
drownding1564123drownding
enrolling1087733enrolling
eroding9314273ero_ding
flowing143411763flow_ing
foaling113515843_foaling
foiling113317653_foiling
fooling113117373_fooling
footling12239923footling
foozling21275723foozling
fouling113315373_fouling
fowlings15377243_fowlings
frilling123011493frilling
frocking18309573frocking
frogging14358733frogging
fronting12310443fronting
frosting12311183frosting
frothing15208533frothing
frowsting1634683frowsting
gaoling93314653gao_ling
glowing123211793glow_ing
goaling93515333_goaling
godling103513403_godling
gosling93312403_gosling
gowning12258833_gowning
grayling1338003grayling
grilling103811533grilling
groaning102410283groaning
groining102310633groining
grokking1334813grokking
grooming12309513grooming
grooving13286713grooving
groping113313103gro_ping
grossing103111063grossing
grouping12308533grouping
grousing103410453grousing
grouting103410793grouting
groveling1435573groveling
growlier1234883growlier
growlingly1842843growlingly
grueling1078273grueling
holing104025073_ho_ling
howking183610313_howking
ironing82414013iro_ning
jowing174216043_jow_ing
knolling13206893knolling
knowing15287683know_ing
kraaling13186663kraaling
lolling83415773_lolling
lordling1077743lordling
lowing104623273_low_ing
meowing1368593meow_ing
mewling13329513_mewling
moiling103417663_moiling
mowing124119093_mow_ing
noodling10209443noodling
ogling83211883__ogling
oiling74925313__oiling
owing96222723__ow_ing
owning104110333__owning
paddling13218643paddling
paling93530133p__aling
palling104024483p_alling
paneling111013623paneling
parawing14310583paraw_ing
parboiling1545173parboiling
parceling1438443parceling
parling103823763p_arling
parodying1655423parodying
patrolling1345693patrolling
pawing124519553p_aw_ing
pawning134711413p_awning
pealing104123203p_ealing
pearling11912013pearling
pebbling1535073pebbling
pedaling122412133pedaling
peddling13217973peddling
peeling102919873p_eeling
periling11316863periling
perilling12410003perilling
pestling111010253pestling
pettling1168213pettling
phoning13312053pho_ning
phonying1745833phonying
photoing1439073photoing
pickling17239203pickling
piddling13208953piddling
piffling1745133piffling
piling95025593p__iling
pilling103722563p_illing
pindling122110983pindling
plodding13166343plodding
plonking15358563plonking
plopping12318703plopping
plotline1037643plotline
plotting113011013plotting
plotzing20276153plotzing
plowland1442743plowland
ploying132811573plo_ying
pocking163916763p_ocking
podding124113183p_odding
poising103617103p_oising
poking133819303p_o_king
poncing122913583p_oncing
ponding114317083p_onding
ponging113416153p_onging
ponying133312123p_onying
pooching16328983pooching
poohing133112323p_oohing
pooing93820683p_o_oing
pooping123615443p_ooping
poplin10413483p_oplin_
poplins11313153p_oplins
popping113715413p_opping
poppling12227323poppling
poring94227273p_o_ring
porking143515813p_orking
porting103021783p_orting
posing93922643p_o_sing
posting105622243p_osting
potline91015233p_otline
potting103720893p_otting
pouring103115863p_ouring
pouting103519943p_outing
powering142210803p_owering
poxing163714943p_o_xing
praising113214563praising
praline93019743pr_aline
prancing132612163prancing
pranging123012723pranging
pranking153813383pranking
prating103424453pr_ating
prattling1246303prattling
praying133717323pr_aying
preboiling1546403preboiling
precooling1545963precooling
preeing103817673pr_eeing
preening113115843preening
prefiling1549533prefiling
prepping12309763prepping
pressing112516443pressing
prevuing1457253prevuing
prewiring1547893prewiring
preying133114553pr_eying
pricing123417343pr_icing
pricking173212603pricking
prickling1836533prickling
priding113317543pr_iding
prigging13299093prigging
priming123417373pr_iming
primming15268173primming
primping15338893primping
prinking153212453prinking
printing113216083printing
prising103321453pr_ising
prissing113011453prissing
prizing193514683pr_izing
probang12278383pro_bang
probating14311193probating
procaine12312273procaine
procuring1437993procuring
producing1556143producing
profaning1537293profaning
profilings1653563profilings
profiting1549983profiting
prolan8414693pro_lan_
prolans9314273pro_lans
proleg94612113pro_l_eg
prolines102619693pro_lines
prolix1538683pro_li_x
prolog94212973pro_l_og
prologing1338953prologing
prolonge11388403pro_longe
prolongs11347613pro_longs
promine112819443pro_mine
promising14410973promising
promoting1439923promoting
prompting1637203prompting
promulging1642683promulging
pronating12313763pronating
prong85218113pro___ng
propelling1556933propelling
propine113020213pro_pine
propining14310133propining
proponing1439993proponing
proposing1439673proposing
prorating12314283prorating
protein92414733protein_
proteins102114283proteins
providing1637963providing
provoking1935133provoking
prowl105615123prowl___
prowled13309913prowl_ed
prowler123310013prowl_er
prowlers13328933prowlers
prowls115511083prowl__s
pruning10311733pr_uning
prying124114803pr__ying
puddling13218033puddling
puling93621403p__uling
pulling103821073p_ulling
pungling12228663pungling
purfling1467763purfling
purling103620293p_urling
purpling1368543purpling
puzzling19225393puzzling
railing83325643_railing
reeling83126863_reeling
reoiling93217213reoiling
rerolling102210373rerolling
rifling112815013_rifling
riling74227973_r_iling
rilling84023623_rilling
roaming103215793_roaming
roaring82916003_roaring
robbing123313213_robbing
robing93618003_ro_bing
rocking143619633_rocking
rockling15259383_rockling
rodding103814533_rodding
roguing9309563_roguing
rolfing113710653_rolfing
rollings9419953_rollings
romping123113033_romping
roofing113814353_roofing
rooking123517363_rooking
rooming104117043_rooming
roosing84018133_roosing
rooting83522433_rooting
rootling9269953rootling
roping94023023_ro_ping
rosing73925593_ro_sing
rotting82919683_rotting
rouging93114703_rouging
rouping103715793_rouping
rousing83920553_rousing
routing83821093_routing
roving103618743_ro_ving
rowelling1366993_rowelling
rowings113710363_row_ings
ruling73219553_r_uling
scowing133812093scow_ing
scrawling15195583scrawling
scrolling12187803scrolling
shawling1558223shawling
shoaling123111753shoaling
shooling123012563shooling
showing143814663show_ing
showring1548323showring
skoaling13227213skoaling
slowing112814743slow_ing
snooling93013473snooling
snowing113913453snow_ing
soiling83422323_soiling
soling74226823_so_ling
sowing104222913_sow_ing
spoiling112911553spoiling
spooling113212563spooling
sprouting1236943sprouting
stooling93113133stooling
stowing113315133stow_ing
strolling10238793strolling
strowing122310563strow_ing
tholing112812333tho_ling
throwing1536723throw_ing
toiling83219023_toiling
toling73926123_to_ling
tolling83418563_tolling
tooling82918313_tooling
tootling9279523tootling
toweling122910373_toweling
towing103823193_tow_ing
towline102911543_towline
trailing92916093trailing
trebling1139873trebling
trifling122411503trifling
trilling92815963trilling
tripling112712553tripling
troaking133310973troaking
trocking153612423trocking
troking123514103tro_king
trollings10286693trollings
trollying1354053trollying
tromping13319603tromping
trooping112710283trooping
trothing122410843trothing
trotline8310023trotline
trotting92510913trotting
troubling1234943troubling
trouping11249503trouping
trowelling1484913trowelling
unrolling1078563unrolling
upboiling1444633upboiling
upcoiling1444793upcoiling
upgrowing1643123upgrow_ing
uprooting1276903uprooting
uprousing1235623uprousing
voling103918023_vo_ling
vowing133715273_vow_ing
vrooming14287353vrooming
wawling143810963_wawling
wowing133915393_wow_ing
wronging13327393wronging
yawling14369183_yawling
yodling123610253_yodling
yowing133715543_yow_ing

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 Limit1461624177.20320291.8
3Display Results4174170.1702452.9
 (SQL Overall)1786914177.79622920.9
 
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.