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

156 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
buoy9592178(None) 
boy87753561b_oy
buoys104810631buoys
bury95633591bury
busy94727171busy
buy86436541bu_y
ahoy101919182ahoy
baby116723682baby
bay89661642b_ay
bevy127115222bevy
bey86645422b_ey
bio57846082bio_
biog76122322biog
bios66335322bios
blob86027092blob
bloc85023272bloc
blog75723822blog
blot65842322blot
blow95827192blow
blowy134315322blowy
bluey104817052bluey
bo410957572b_o_
boa56954032b_oa
bob76755672b_ob
bod67055542b_od
body107425672body
bog67852412b_og
bogy106426192bogy
bony96732082bony
boo58163662b_oo
boob85932582boob
booby125319512booby
boody115420402boody
boogy114518322boogy
book106836332book
boom87435672boom
boomy125421822boomy
boon67142172boon
boor66130682boor
boos67955032boos
boot67759372boot
booty106125912booty
boozy194917062boozy
bop77549482b_op
bos57966812b_os
bot59680402b_ot
bousy104917842bousy
bout66353292bout
bow87051902b_ow
box1210142342b_ox
boxy166420732boxy
boyo96923842b_oyo
boys96737332b_oys
bray95232902bray
bro56236602bro_
broo65129822broo
bros65635662bros
brosy106115382brosy
brow97228442brow
bub76343982bu_b
bubby115013932bubby
bubo85621912bubo
bubs86235502bubs
bubu85022672bubu
buck125129902buck
bud67041272bu_d
buddy124812632buddy
buds75235172buds
buff125229862buff
buffy165013372buffy
bug65340742bu_g
buggy124613482buggy
bugs76035912bugs
buhl95518222buhl
buhr95315382buhr
bulb85626692bulb
bulgy115214102bulgy
bulk105426152bulk
bulky146215572bulky
bull65634872bull
bully105124812bully
bum75342692bu_m
bumf116126512bumf
bump106228242bump
bumpy144715052bumpy
bums85934592bums
bun56348142bu_n
buna64730722buna
bund75530662bund
bung75730632bung
bunk105731352bunk
bunn65023652bunn
bunny104715802bunny
buns66243722buns
bunt65850852bunt
bunya103810092bunya
buoyed1236692buoyed
buppy144810072buppy
bur55744692bu_r
bura66139532bura
burb85334672burb
burd75534262burd
burg74930362burg
burl64937182burl
burly104922832burly
burn65636432burn
burp85028882burp
burr65631232burr
burry105221562burry
burs65847422burs
bus56950972bu_s
busboy13307442busboy
busby126113292busby
bush96630712bush
bushy135416682bushy
busk105429222busk
buss65134912buss
bust65947782bust
busty105621012busty
but55963022bu_t
bute66739672bute
buts67247692buts
butt65143742butt
butty104020112butty
butyl1089102butyl
buxom1647152buxom
buys95726792buys
buzz146617802buzz
by77529232b__y
cloy96623832cloy
coy810557552_coy
duly85323032duly
duo48536142duo_
duos56728132duos
duty85321452duty
foy96044262_foy
fumy127118582fumy
fury107727972fury
goy77844552_goy
guy75728942gu_y
hoy97447912_hoy
joy137036362_joy
jury146719592jury
luny77324132luny
muon65722732muon
oy58950132__oy
ploy96123602ploy
puny95526992puny
quay164618352quay
quey164616472quey
quod145413622quod
ruby97819942ruby
ruly76323142ruly
soy67851452_soy
toy69655192_toy
troy77429682troy

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 Filter178691298720.280638182.1
2DLD Change Limit298721560.90632971.3
3Display Results1561560.0305200.0
 (SQL Overall)1786911561.216146949.8
 
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.