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

368 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
brooming13291114(None) 
blooming13299431blooming
booming123716221b_ooming
brooding122911371brooding
brooking153710701brooking
grooming12309511grooming
rooming104117041_rooming
vrooming14287351vrooming
becoming1538162becoming
blooding122410652blooding
blooping13248842blooping
boobing123613912b_oobing
booing94521642b_oo_ing
booking143618382b_ooking
booting103821362b_ooting
boozing194012162b_oozing
bosoming1336642bosoming
breaming133612512breaming
brimming15196622brimming
broiling113112012broiling
broking143514822br_oking
bromin102615692br_omin_
bromine112915242br_omine
bromins112513782br_omins
bronzing2037692bronzing
broomier1236872broomier
browning14299642browning
browsing14319352browsing
crooking153611342crooking
crooning113112112crooning
dooming113112532_dooming
drooling102610422drooling
drooping12268802drooping
glooming12358012glooming
grooving13286712grooving
looming102814852_looming
promoing13310462promoing
proofing1439312proofing
roaming103215792_roaming
roofing113814352_roofing
rooking123517362_rooking
roosing84018132_roosing
rooting83522432_rooting
trooping112710272trooping
varooming1545082varooming
zooming19269652_zooming
arming94719803ar__ming
armoring1149123armoring
arousing93811803arousing
arrowing1237943arrowing
bamming144611813b_amming
beaming123618803b_eaming
becomings1643773becomings
befooling1535053befooling
beglooming1642953beglooming
behooving1843743behooving
behoving1734913behoving
benaming1339693benaming
berhyming2042703berhyming
beriming13310453beriming
berming123614823b_erming
beworming1734553beworming
blaming123515693b_laming
bloating113512813bloating
blobbing12246923blobbing
blocking174510573blocking
blogging13369013blogging
bloodings13245273bloodings
bloodying1643783bloodying
bloomier1275783bloomier
blossoming1542383blossoming
blotting113910433blotting
blousing1138793blousing
blowing133813053b_lowing
bluming123511283b_luming
boating103721303b_oating
bobbing113113193b_obbing
boding104320063b__oding
bodying1438973b_odying
boffing16339983b_offing
bogging123615753b_ogging
boiling103819673b_oiling
boing84725553b__o_ing
bolling103820883b_olling
bolting104416763b_olting
bombing143211383b_ombing
bonding113318433b_onding
bonging113316373b_onging
boning94223293b__oning
bonking144116373b_onking
boodling121910243boodling
boogying1535373boogying
boohooing1563423boohooing
bookings15358733b_ookings
boomier113312183b_oomier
boomingly1744793b_oomingly
boomkin1545363b_oomkin_
boomkins1645503b_oomkins
boosting113311053boosting
bopping143512033b_opping
borating113414503borating
boring94724873b__oring
borking144716173b_orking
borrowing1544563borrowing
bossing103714603b_ossing
bottoming1444433bottoming
bousing103718043b_ousing
bowing124723063b__owing
bowling133916493b_owling
bowsing134012503b_owsing
boxing163915153b__oxing
bracing123817613br_acing
bradding13268933bradding
bragging13359333bragging
braiding123112703braiding
brailing113514793brailing
braining113414683braining
braising113014563braising
braking143917703br_aking
branding122513683branding
branning112911093branning
brassing112612303brassing
braving133714613br_aving
bravoing1445993bravoing
brawling143210043brawling
braying134416313br_aying
brazing193715113br_azing
breading123515463breading
breaking153914243breaking
breeding123411843breeding
breezing20368133breezing
brewing133411153br_ewing
bribing123111043br_ibing
bricking173911403bricking
bridging13288443bridging
bridling122610583bridling
briefing1436943briefing
bring85528503br___ing
bringing123011273bringing
brining103216473br_ining
brisking15329473brisking
brisling112410843brisling
broaching17287663broaching
brocading1556253brocading
brokering1636283brokering
brokings15317703br_okings
bromating1439153bromating
bromic122412693br_omi_c
bromid112612893br_omi_d
bromide12269583br_omide
bromids12278603br_omids
bromines122514253br_omines
bromism1337623br_omism
bromize20238823br_omize
bromizing2346583bromizing
bronzings2143643bronzings
broodier1157433broodier
broodily1445503broodily
broodingly1743393broodingly
brookie1347373brooki_e
brookies1459143brookies
brookite1445503brookite
broom95022213broom___
broomed124111053broom_ed
broomiest1356913broomiest
brooms104915873broom__s
broomy13449953broom__y
bruising11279143bruising
bruiting11259973bruiting
brushing14359963brushing
bruting102612993br_uting
bruxing17236823br_uxing
bumming143410783b_umming
buoying13379953b_uoying
burrowing1544473burrowing
caroming133312963caroming
carroming1437673carroming
choosing142010133choosing
chroming163410723chroming
coaming123818323_coaming
coming114225453__coming
cooing94024923_coo_ing
cooking143818973_cooking
cooling103422573_cooling
cooping123918933_cooping
cramming15339433cramming
creaming133413143creaming
croaking153712153croaking
crocking174313443crocking
cropping153210883cropping
crossing112612683crossing
crowding15247933crowding
crowing133814763cr_owing
crowning143510033crowning
doming104218393__doming
dramming14347563dramming
dreaming124011063dreaming
drolling103510763drolling
droning93013723dr_oning
dropping14309283dropping
drouking1436443drouking
droving12379683dr_oving
drowning13298363drowning
drowsing13287773drowsing
drumming14265783drumming
enrooting10128133enrooting
eroding9314273er_oding
flooding13238963flooding
flooring12259883flooring
foaming133612993_foaming
fooling113117373_fooling
footing115017593_footing
forming133615733_forming
framing133014793fr_aming
frocking18309573frocking
frogging14358733frogging
fronting12310443fronting
frosting12311183frosting
frothing15208533frothing
frowning15307833frowning
gloaming12268013gloaming
glomming14275923glomming
gloomings13283973gloomings
goofing123510633_goofing
goosing93314083_goosing
gorming112810833_gorming
griming113612493gr_iming
groaning102410283groaning
groining102310633groining
grokking1334813grokking
groping113313103gr_oping
grossing103111063grossing
grouping12308533grouping
grousing103410453grousing
grouting103410793grouting
growing123512473gr_owing
growling1348163growling
homing123718383__homing
hooding123815203_hooding
hoofing143912553_hoofing
hooking153716693_hooking
hooping133615703_hooping
hooting113919873_hooting
incoming1349863incoming
ironing82414013ir_oning
loaming103613733_loaming
looing73621043_loo_ing
looking123415043_looking
looping103615283_looping
loosing83515963_loosing
looting83019643_looting
marooning1238593marooning
mooing93718373_moo_ing
mooning103415553_mooning
mooring102514443_mooring
mooting103019363_mooting
nooning83014853_nooning
noosing83315053_noosing
oncoming1338353oncoming
oohing104412933__oohing
oozing163812203__oozing
poohing133112323_poohing
pooing93820683_poo_ing
pooling103219093_pooling
pooping123615443_pooping
priming123417373pr_iming
primming15268173primming
probing123314443pr_obing
prodding13189343prodding
progging132610383progging
prologing1338953prologing
promine112819443pr_omine
promoting1439913promoting
pronging123511843pronging
proponing1439993proponing
proposing1439673proposing
propping122811673propping
prosing103319383pr_osing
proving134214073pr_oving
provoking1935133provoking
prowling1449993prowling
ramming123115063_ramming
reaming103924013_reaming
reblooming1543423reblooming
regrooming1464163regrooming
reroofing1336863reroofing
rhyming1634033_rhyming
riming93322213_r_iming
rimming123411063_rimming
rioting82716393_rioting
roaring82916003_roaring
robbing123313213_robbing
robing93617993_r_obing
rocking143619633_rocking
rodding103814533_rodding
roguing9309563_roguing
roiling83220453_roiling
rolfing113710653_rolfing
rolling83620413_rolling
romping123113033_romping
roofings12256023_roofings
roomie83013873_roomi_e
roomier93812243_roomier
roomies93017243_roomies
roomily1237283_roomily
roosting93411453_roosting
rootling9269953_rootling
roping94023023_r_oping
rosing73925593_r_osing
rotting82919683_rotting
rouging93114703_rouging
rouping103715793_rouping
rousing83920553_rousing
routing83821093_routing
roving103618743_r_oving
rowing103623303_r_owing
scooping133610633scooping
scooting113012633scooting
scrooping1446593scrooping
shooing112112903shoo_ing
shooling123012553shooling
shooting122812843shooting
snooding102910433snooding
snooking133010583snooking
snooling93013473snooling
snooping113811323snooping
snooting92813193snooting
snoozing18319073snoozing
sooting82820953_sooting
spoofing14228363spoofing
spooking15269803spooking
spooling113212563spooling
spooning112811443spooning
spooring113111463spooring
stooging102810043stooging
stooking132711143stooking
stooling93113133stooling
stooping113012363stooping
storming11209423storming
swooning12278203swooning
swooping14338403swooping
tomming12359243_tomming
tooling82918313_tooling
tooting83019423_tooting
tramming13279343tramming
trimming13318653trimming
troaking133310963troaking
trocking153612423trocking
troking123514103tr_oking
trolling93212493trolling
tromping13319593tromping
trothing122410843trothing
trotting92510913trotting
trouping11249503trouping
trowing113413703tr_owing
unroofing1385703unroofing
unrooting1098833unrooting
upcoming1535173upcoming
uprooting1276903uprooting
venoming1436403venoming
whoofing18234833whoofing
whooping17286633whooping
wooding123012023_wooding
woofing14349893_woofing
wooing104214663_woo_ing
worming132811243_worming
wronging13327393wronging
zooning172910703_zooning

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.1531167915.0
2DLD Change Limit1461623687.70618967.3
3Display Results3683680.1532405.2
 (SQL Overall)1786913688.01222302.9
 
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.