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

351 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
drooping1226880(None) 
drooling102610421drooling
dropping14309281dropping
trooping112710271trooping
blooping13248842blooping
brooding122911372brooding
brooking153710702brooking
brooming132911142brooming
cooping123918932_cooping
crooking153611342crooking
crooning113112112crooning
cropping153210882cropping
dooming113112532d_ooming
doping103919462d__oping
draping114213352dr_aping
dripping14278032dripping
drolling103510762drolling
droning93013722dr_oning
droopier1145572droopier
droopily1443942droopily
droopingly1742572droopingly
droppings15264502droppings
drouking1436442drouking
droving12379682dr_oving
drowning13298362drowning
drowsing13287772drowsing
grooming12309512grooming
grooving13286712grooving
groping113313102gr_oping
grouping12308532grouping
hooping133615702_hooping
looping103615282_looping
pooping123615442_pooping
proofing1439312proofing
propping122811672propping
romping123113032_romping
roofing113814352_roofing
rooking123517362_rooking
rooming104117042_rooming
roosing84018132_roosing
rooting83522432_rooting
roping94023022_r_oping
rouping103715792_rouping
scooping133610632scooping
scrooping1446592scrooping
snooping113811322snooping
stooping113012362stooping
swooping14338402swooping
tromping13319592tromping
trouping11249502trouping
vrooming14287352vrooming
whooping17286632whooping
armoring1149123armoring
arousing93811803arousing
arrowing1237943arrowing
blooding122410653blooding
blooming13299433blooming
boobing123613913_boobing
booing94521643_boo_ing
booking143618383_booking
booming123716223_booming
booting103821363_booting
boozing194012163_boozing
bopping143512033_bopping
broiling113112013broiling
broking143514823br_oking
bronzing2037693bronzing
browning14299643browning
browsing14319353browsing
chomping18339883chomping
choosing142010133choosing
chopping183710263chopping
clomping15329653clomping
clopping153511083clopping
comping143518593_comping
cooing94024923_coo_ing
cooking143818973_cooking
cooling103422573_cooling
coopting133411313_coopting
coping113927663__coping
copping143918593_copping
couping124317023_couping
cramping153411853cramping
craping124018713cr_aping
crapping153911453crapping
creeping133310103creeping
creping122913653cr_eping
crimping15299783crimping
crisping13319663crisping
croaking153712153croaking
crocking174313443crocking
crossing112612683crossing
crowding15247933crowding
crowing133814763cr_owing
crowning143510033crowning
crumping15319903crumping
dadoing1038523dado_ing
damping133414003d_amping
dapping133714793d_apping
deboning12109153deboning
decoding132410053decoding
decoying15208763decoying
demoing11311753demo_ing
demoting12311423demoting
denoting10311753denoting
deponing121211213deponing
deposing12129773deposing
detoxing1736313detoxing
devoting1338823devoting
dewooling1444323dewooling
dipping134014833d_ipping
disrooting1247743disrooting
doating93816863d_oating
docking153615013d_ocking
dodging11299063d_odging
doffing15357793d_offing
dogging113312693d_ogging
doing74923583d__o_ing
doling84923133d__oling
dolling93817373d_olling
dolloping1344993dolloping
doming104218393d__oming
donning93512763d_onning
doodling11218403doodling
dopings11408783d__opings
dosing83920273d__osing
dossing93313273d_ossing
doting84821913d__oting
dotting93314483d_otting
dousing93315763d_ousing
dowing114221513d__owing
downing123811673d_owning
dowsing123411123d_owsing
dozing174214193d__ozing
drabbing14286803drabbing
drafting13339403drafting
dragging12308103dragging
dragooning1342883dragooning
draining103312673draining
dramming14347563dramming
dratting10389653dratting
drawing123812053dr_awing
drawling13318673drawling
draying123813843dr_aying
dreading113712803dreading
dreaming124011063dreaming
dredging12236423dredging
dreeing94311183dr_eeing
dressing102810423dressing
dribbing14325883dribbing
drifting13338733drifting
drilling103311983drilling
drinking14308913drinking
drippings15313903drippings
driving123910713dr_iving
droolier936073droolier
droop85814823droop___
drooped11368433droop_ed
droopiest1235743droopiest
droops95110963droop__s
droopy12458243droop__y
drownding1564123drownding
drubbing14286053drubbing
drudging12256233drudging
drugging12326443drugging
drumming14265783drumming
drying113411603dr__ying
drypoint1444793drypoint
dumping133712913d_umping
duping104113633d__uping
dupping133711043d_upping
eloping103512833_eloping
enrooting10128133enrooting
eroding9314273er_oding
flooding13238963flooding
flooring12259883flooring
flopping16388773flopping
fooling113117373_fooling
footing115017593_footing
fopping153511133_fopping
frapping16348103frapping
frocking18309573frocking
frogging14358733frogging
fronting12310443fronting
frosting12311183frosting
frothing15208533frothing
frowning15307833frowning
gadrooning1343543gadrooning
galoping1258023galoping
glooming12358013glooming
glopping14307753glopping
goofing123510633_goofing
goosing93314083_goosing
grasping12348833grasping
griping113012063gr_iping
gripping14277543gripping
groaning102410283groaning
groining102310633groining
grokking1334813grokking
grossing103111063grossing
groupings13273813groupings
grousing103410453grousing
grouting103410793grouting
growing123512473gr_owing
growling1348163growling
grumping14266903grumping
hooding123815203_hooding
hoofing143912553_hoofing
hooking153716693_hooking
hooting113919873_hooting
hoping123719743__hoping
hopping154115273_hopping
ironing82414013ir_oning
looing73621043_loo_ing
looking123415043_looking
looming102814853_looming
loosing83515963_loosing
looting83019643_looting
loping93921413__loping
lopping123815223_lopping
louping104313983_louping
marooning1238593marooning
mooing93718373_moo_ing
mooning103415553_mooning
mooring102514443_mooring
mooting103019363_mooting
moping114017103__moping
mopping143411473_mopping
nooning83014853_nooning
noosing83315053_noosing
oohing104412933__oohing
oozing163812203__oozing
oping86322413___oping
plopping12318703plopping
poohing133112323_poohing
pooing93820683_poo_ing
pooling103219093_pooling
popping113715413_popping
prepping12309763prepping
primping15338893primping
probing123314443pr_obing
prodding13189343prodding
progging132610383progging
prologing1338953prologing
promoing13310463promoing
promoting1439913promoting
prompting1637193prompting
pronging123511843pronging
propine113020213pr_opine
proponing1439993proponing
proposing1439673proposing
prosing103319383pr_osing
proving134214073pr_oving
provoking1935133provoking
prowling1449993prowling
ramping123316873_ramping
raping94829853_r_aping
rapping123619103_rapping
rasping104316253_rasping
reaping103621213_reaping
repping123314983_repping
reroofing1336863reroofing
rioting82716393_rioting
riping93821613_r_iping
ripping123315743_ripping
roaming103215793_roaming
roaring82916003_roaring
robbing123313213_robbing
robing93618003_r_obing
rocking143619633_rocking
rodding103814533_rodding
roguing9309563_roguing
roiling83220453_roiling
rolfing113710653_rolfing
rolling83620413_rolling
roofings12256023_roofings
roosting93411453_roosting
rootling9269953_rootling
rosing73925593_r_osing
rotting82919683_rotting
rouging93114703_rouging
rousing83920553_rousing
routing83821093_routing
roving103618743_r_oving
rowing103623303_r_owing
scooting113012633scooting
scoping123513823_scoping
shooing112112903shoo_ing
shooling123012553shooling
shooting122812843shooting
shopping163611283shopping
sloping104114073_sloping
slopping133811423slopping
snooding102910433snooding
snooking133010583snooking
snooling93013473snooling
snooting92813193snooting
snoozing18319073snoozing
soaping103616223_soaping
sooting82820953_sooting
sopping123917203_sopping
souping104215533_souping
spoofing14228363spoofing
spooking15269803spooking
spooling113212563spooling
spooning112811443spooning
spooring113111463spooring
stomping13309763stomping
stooging102810043stooging
stooking132711143stooking
stooling93113133stooling
stoping103716623_stoping
stopping133611413stopping
stropping1436933stropping
swooning12278203swooning
swopping16377963swopping
tooling82918313_tooling
tooting83019423_tooting
toping94122993__toping
topping123514623_topping
tramping132711273tramping
trapping132911393trapping
tripping133210923tripping
troaking133310963troaking
trocking153612423trocking
troking123514103tr_oking
trolling93212493trolling
troopial1045483troopial
tropin83316753tr_opin_
tropine93116653tr_opine
tropins93116303tr_opins
trothing122410843trothing
trotting92510913trotting
trowing113413703tr_owing
trumping13308733trumping
unroofing1385703unroofing
unrooting1098833unrooting
uprooting1276903uprooting
urping93914053ur__ping
varooming1545083varooming
whomping19285943whomping
whoofing18234833whoofing
whopping19357373whopping
wooding123012023_wooding
woofing14349893_woofing
wooing104214663_woo_ing
woopsing1435633_woopsing
wrapping16297623wrapping
wronging13327393wronging
zooming19269653_zooming
zooning172910703_zooning

Search took 10 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.186960704.3
2DLD Change Limit1461623518.92316380.4
3Display Results3513510.1402507.1
 (SQL Overall)1786913519.24919320.0
 
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.