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 “boost” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

147 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
boost7513247(None) 
boast75935701boast
boos67955031boos_
boosts86115011boosts
boot67759371boo_t
boots75837971boots
roost55730931roost
bast66362412b_ast
beast76338642beast
besot76429712besot
best66355322b_est
bhoot104322092bhoot
bhoots11459902bhoots
biont7727162biont
bios66335322bios_
blast76532572blast
blest76431722blest
bloat75229922bloat
blot65842322blo_t
blots75626172blots
boart78835932boart
boas66150832boas_
boasts85017922boasts
boat66360312b_oat
boats75635152boats
bobs86340652bobs_
bods76244712bods_
bogs75742752bogs_
bohos105618252bohos_
bolos75531372bolos_
bolt66254172b_olt
bolts76232112bolts
boo58163662boo__
boob85932582boo_b
boobs96221992boobs
booby125319512booby
boody115420402boody
booed85127272booed
boogy114518322boogy
book106836332boo_k
books115729712books
boom87435672boo_m
booms95427122booms
boomy125421822boomy
boon67142172boo_n
boons75031912boons
boor66130682boo_r
boors74325012boors
boosted104111982boosted
booster94314552booster
booth105522012booth
booty106125912booty
booze164718912booze
boozy194917062boozy
bops86037982bops_
borsht11813502borsht
bort65960962b_ort
borts76735452borts
bos57966812b_os_
bosh96328972b_osh
bosk105825732b_osk
bosom95516922bosom
boson76019732boson
boss65938342b_oss
bossy105515972bossy
bot59680402b_o_t
bots66453952bots_
bott66548572b_ott
botts75224862botts
bouse75931852bouse
bousy104917842bousy
bout66353292b_out
bouts75131312bouts
bows96242862bows_
bowse105420632bowse
boyos105418282boyos_
boys96737332boys_
bozos165216862bozos_
broos75126412broos_
bros65635662bros_
brose75227032brose
brosy106115382brosy
burst75332242burst
bust65947782b_ust
coast75236262coast
cohost115217212cohost
coopt95929852coopt
coos67456492coos_
coot67860382coo_t
coots75636842coots
cost68057942_cost
doest65829522doest
dost57248352_dost
foist85730972foist
foot76248012foo_t
foots85528282foots
frost84727832frost
ghost96318762ghost
glost65422932glost
goos57644912goos_
goose65925902goose
goosy96018882goosy
hoist86433212hoist
hoot75752092hoo_t
hoots84830242hoots
horst85833512horst
host77852832_host
joist125125652joist
joust125122292joust
loos49051122loos_
loose56627682loose
loot46955822loo_t
loots55431422loots
lost47951492_lost
moist76033582moist
moos66051302moos_
moose76327192moose
moot67653622moo_t
moots75831662moots
most66554202_most
noose55624062noose
oast47156322_oast
oboist8312682oboist
oot311274692_oo_t
oots46446442_oots
oust46747442_oust
poos65949112poos_
post67953362_post
prost75434102prost
roast56230142roast
roose56127092roose
roosts64916322roosts
root45655922roo_t
roots55933672roots
roust55532062roust
soot45761052soo_t
soots55536202soots
toast55831012toast
toot45958882too_t
toots55331872toots
tost48351922_tost
volost9412642volost
woos76238802woos_
woosh113710732woosh
worst86330132worst
wost76544362_wost
zoos135828802zoos_

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001471.78030224.7
3Display Results1471470.0463195.7
 (SQL Overall)1786911471.91993116.7
 
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.