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

224 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
bogy10642619(None) 
body107425671body
bog67852411bog_
bogey115220231bogey
boggy126116071boggy
bogs75742751bogs
bony96732081bony
boogy114518321boogy
boxy166420731boxy
boy87753561bo_y
dogy96126491dogy
fogy115923181fogy
logy87025781logy
pogy105623551pogy
baby116723682baby
bag67059222bag_
baggy125615682baggy
bags76645502bags
bay89661642b_ay
beg65944132beg_
begs75733832begs
beigy111110582beigy
bevy127115222bevy
bey86645422b_ey
big67345722big_
biggy124413132biggy
bigly114814752bigly
bigs76235022bigs
bilgy114713712bilgy
biog76122322biog_
biogs85016112biogs
blog75723822blog_
blogs85319232blogs
blowy134315322blowy
bo410957572bo__
boa56954032bo_a
boar66134292boar
boas66150832boas
boat66360312boat
bob76755672bo_b
bobby114814662bobby
bobs86340652bobs
bock126032512bock
bod67055542bo_d
bode75838752bode
bods76244712bods
boff124727332boff
bogan87519002bogan
bogeys124510912bogeys
bogie89524102bogie
bogle85821682bogle
bogus85616472bogus
boho96923322boho
boil66335182boil
bola66035562bola
bold75432812bold
bole66448692bole
boll65634752boll
bolo65535952bolo
bolt66254172bolt
bomb106927422bomb
bond75334362bond
bone65949322bone
boney105227312boney
bong75633412bong
bongo85720942bongo
bongs87828422bongs
bonk105531712bonk
bonny105816622bonny
boo58163662bo_o
boob85932582boob
booby125319512booby
boody115420402boody
boogey124711522boogey
book106836332book
boom87435672boom
boomy125421822boomy
boon67142172boon
boor66130682boor
boos67955032boos
boot67759372boot
booty106125912booty
boozy194917062boozy
bop77549482bo_p
bops86037982bops
bora66141632bora
bore66051332bore
bork106933822bork
born67338412born
bort65960962bort
borty105522832borty
bos57966812bo_s
bosh96328972bosh
bosk105825732bosk
bosky145612392bosky
boss65938342boss
bossy105515972bossy
bot59680402bo_t
bota66236502bota
both96533432both
bothy136713962bothy
bots66453952bots
bott66548572bott
bough115719312bough
bousy104917842bousy
bout66353292bout
bow87051902bo_w
bowl96827702bowl
bows96242862bows
box1210142342bo_x
boyo96923842boyo
boys96737332boys
bozo156821412bozo
bray95232902bray
brosy106115382brosy
bug65340742bug_
buggy124613482buggy
bugs76035912bugs
bulgy115214102bulgy
buoy95921782buoy
bury95633592bury
busy94727172busy
buy86436542b_uy
by77529232b__y
cagy106321992cagy
cog69552902cog_
cogs77340032cogs
coky137526822coky
coly96940532coly
cony96537832cony
copy116229802copy
cory96941512cory
cosy97232702cosy
cowy126427362cowy
coy810557552co_y
cozy185823802cozy
doby106022162doby
dodgy116611462dodgy
dog57449752dog_
doge66233802doge
dogey105719512dogey
doggy115214872doggy
dogs66440152dogs
dopy106224152dopy
dory85836232dory
doty86128222doty
doxy156419952doxy
dozy175920322dozy
ebony104511512ebony
edgy94713522edgy
eggy96611852eggy
fog76945562fog_
fogey125617872fogey
foggy136714542foggy
fogs87035002fogs
foxy176517752foxy
foy96044262fo_y
fozy197017162fozy
goby106021082goby
gogo69722832gogo
gory86129662gory
goy77844552go_y
hoagy124710472hoagy
hog78049062hog_
hogg96617532hogg
hogs87139662hogs
holy106333432holy
homy126623222homy
hoy97447912ho_y
joey145719332joey
jog117438312jog_
jogs127129332jogs
joky186215312joky
joy137036362jo_y
log46252682log_
loge56837192loge
loggy105714192loggy
logo57931762logo
logs57343112logs
lory75931712lory
mog66949672mog_
moggy125212162moggy
mogs75439332mogs
moly96031912moly
mony96830012mony
mopy115721972mopy
nog46847312nog_
nogg65115942nogg
nogs56534612nogs
nosy76322892nosy
obey96521302obey
ology94113112ology
oozy167018132oozy
orgy85218002orgy
oxy136320982_oxy
oy58950132_o_y
podgy125610772podgy
pogey116017892pogey
poky135922152poky
poly96235152poly
pony96434052pony
porgy116916122porgy
posy96028422posy
poxy166820892poxy
ropy96323412ropy
rosy76024872rosy
sagy85327082sagy
soggy105413902soggy
soy67851452so_y
stogy95414082stogy
toby96322292toby
tody86327212tody
tog410255042tog_
toga57027412toga
togs57242432togs
tony75635152tony
tory75840542tory
towy105325472towy
toy69655192to_y
wog76242732wog_
wogs86531402wogs
yoga87418052yoga
yogh116616142yogh
yogi86120422yogi

Search took 1 second 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.0632836365.1
2DLD Change Limit298722240.83035990.4
3Display Results2242240.0464869.6
 (SQL Overall)1786912240.939190299.3
 
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.