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

214 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
boomlet11241227(None) 
booklet132312641booklet
boomlets12246671boomlets
bomblet13412262bomblet
boodle93215032boodle_
boodled113410932boodled
boodler103312002boodler
boodles103416042boodles
booklets14247122booklets
boomed115318132boom_ed
boomer104618512boom_er
boomier113312182boomier
boomiest122711842boomiest
bootleg10276632bootleg
brooklet1456402brooklet
hooklet142510812hooklet
moonlet92413272moonlet
rootlet73015732rootlet
armlet84118193_armlet
ballet84733973b_allet
billet86029723b_illet
biome94916993biom_e_
biomes103815253biom_es
blet66247673b___let
bloomed12439433bloom_ed
bloomer11419813bloom_er
bloomier1275783bloomier
bloomiest1335853bloomiest
bloomless1342963bloomless
bobble94115143bobble_
bobbled113811833bobbled
bobbles104514913bobbles
bobsled12297153bobsled
boggle104511943boggle_
boggled12409003boggled
boggler113910083boggler
boggles113411823boggles
bogle85821683b_ogle_
bogles95020833b_ogles
boiled95020953b_oiled
boiler84319273b_oiler
bole66448693b_o_le_
boles75448603b_o_les
bolete8519613b_o_lete
boleti8413403b_o_leti
bolled94722653b_olled
bolt66254173b_o_l_t
bombe115519313b_ombe_
bombed134113873b_ombed
bomber125014653b_omber
bombes124916823b_ombes
bomblets1436023bomblets
boneset9316433boneset
bonnet85524633b_onnet
boobed114514873boo_bed
boobie104015293boobie_
boobies113718203boobies
boodies103721443boodies
boodlers113710743boodlers
booed85127273boo__ed
booger94816553boo_ger
boogey124711523boo_gey
boogie93515993boogie_
boogied11379283boogied
boogies103719013boogies
booked135319503boo_ked
booker124719193boo_ker
bookie123516003bookie_
bookies133819403bookies
bookmen15126263bookmen
bookrest1436493bookrest
boom87435673boom___
boombox2073613boombox
boomers114115913boomers
booming123716223booming
boomkin1545363boomkin
booms95427123boom__s
boomy125421823boom__y
boonies93422483boonies
boonless10328353boonless
boost75132473boo__st
boosted104111983boosted
booster94314553booster
boot67759373boo___t
booted94822733boo_ted
bootee84323023boo_tee
bootees94114473bootees
bootie85421153bootie_
booties94124613booties
bootlegs11325873bootlegs
bootless103410983bootless
booze164718913boo_ze_
boozed184813833boo_zed
boozer174815963boo_zer
boozes174916523boo_zes
boozier18349013boozier
booziest19379263booziest
bosket124919223b_osket
bosomed1238003bosom_ed
bosquet18249223bosquet
bottle84916073bottle_
bottled104611233bottled
bottler94211883bottler
bottles94216273bottles
boucle103712783boucle_
boucles113113003boucles
boule74828043b_oule_
boules84925973b_oules
boulle84614613boulle_
boulles93114123boulles
bouquet18288263bouquet
boweled132810693boweled
bowled125018133b_owled
bowleg12369173b_owleg
bowler114217313b_owler
bowmen1399853bowm_en
brocket154013383brocket
broiled103811423broiled
broiler92911753broiler
bromate11313553bromate
brome94421973brom_e_
bromes104719763brom_es
brooklets1543683brooklets
broomed124111053broom_ed
broomier1236873broomier
broomiest1356913broomiest
bulblet11311213bulblet
bullet84528613b_ullet
camlet104426583_camlet
collet84030363_collet
comet95946073_com_et
cooled95224583coo_led
cooler84824713coo_ler
coolest9318643coo_lest
coombe124110093coombe_
coombes133810663coombes
corslet9318063corslet
couplet114717943couplet
doodle83212853doodle_
doodled10369463doodled
doodler93310153doodler
doodles93614163doodles
doolee73018953doo_lee
doomed104113293doom_ed
doomier103610123doomier
doomiest112910453doomiest
doublet103914033doublet
droplet10312113droplet
fooled104317823foo_led
footle93914383footle_
footled113610763footled
footler104011873footler
footles103715713footles
foozle18369203foozle_
foozled20346893foozled
foozler19397593foozler
foozles19329543foozles
froglet11310063froglet
gimlet93716663_gimlet
goblet93219483_goblet
goglet84618583_goglet
grommet12268453grommet
hamlet113722793_hamlet
hooklets15217203hooklets
howlet123518343_howlet
loomed94616763loom_ed
mooley11311633moo_ley
moonlets10247473moonlets
moonlit9229333moonlit
moonset92413043moonset
noodle73212543noodle_
noodled9339923noodled
noodles83513193noodles
obole75917143obo_le_
oboles83815833obo_les
omelet8317073_omelet
oodles73517183_oodles
outlet63728683_outlet
owlet83324463__owlet
piolet83225643pio_let
poodle93112043poodle_
poodles103013513poodles
pooled94619813poo_led
pooler83819843poo_ler
roomed95218543room_ed
roomer84718633room_er
roomie83013873roomie_
roomier93812243roomier
roomies93017243roomies
roomiest102611993roomiest
rootle63214453rootle_
rootled83410533rootled
rootles73215633rootles
rootlets8308653rootlets
samlet84126563_samlet
toilet66228093_toilet
tonlet62924703_tonlet
tooled74918903too_led
tooler63818613too_ler
tootle62613813tootle_
tootled83511043tootled
tootler73511123tootler
tootles72915603tootles
townlet1049733townlet
violet92620923vio_let
woodlot1147023woodlot
wooled103715503woo_led
woolen93111373woo_len
wooler93615873woo_ler
woolled1136643woolled
woollen1034723woollen
woolmen1234973woolmen
zooglea1733373zooglea
zoomed183610363zoom_ed

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272147.14018771.3
3Display Results2142140.0762815.8
 (SQL Overall)1786912147.37224239.1
 
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.