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

382 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
bouncy1340907(None) 
bounce104014831bounce
bounty113411071bounty
jouncy18336201jouncy
boney105227312bo_ney
bonny105816622bo_nny
bony96732082bo_n_y
bounced123610552bounced
bouncer113811332bouncer
bounces113813682bounces
bouncily1544382bouncily
bound84819582boun_d
bounds94415802bounds
bousy104917842bou_sy
brunch13329352brunch
bunch125118602b_unch
bunchy16437462b_unchy
bunco94616082b_unco
bunny104715802b_unny
county114313322county
flouncy1543672flouncy
jounce153310732jounce
loungy10476832loungy
ounce77019932_ounce
pounce105214092pounce
unbouncy1552862unbouncy
abound9239863aboun_d
abounds10217083abounds
adunc837433adunc_
agency1237033agency
aunty85919813_aunty
banco94019393b_anco
bandy114824183b_andy
banty106624003b_anty
barney115314453barney
barny105821733barn_y
baulky15446313baulky
bedunce1235683bedunce
bench125619503b_ench
bendy115017253b_endy
benny105217363b_enny
blanch133410853blanch
blench133710453blench
blenny1156203blenny
blousy11459123blou_sy
bluely113310083bluely
bluesy11448983bluesy
bluey104817053blu_ey
blunge94311483blunge
blunt75525023blun_t
bluntly1235223bluntly
blunts84512893blunts
blurry11437673blurry
bobby114814653bo_bby
bocce114313113bo_cce
bocci113512713bo_cci
bock126032513bo__ck
bodice11711423bodice
bodily12310993bodily
body107425673bo__dy
bogey115220233bo_gey
boggy126116073bo_ggy
bogusly1343893bogusly
bogy106426193bo__gy
bohunk1533743bohun_k
bohunks1632943bohunks
boing84725553boin_g
boings96416873boings
boink115516333boin_k
boinks125211273boinks
boldly12399423boldly
boloney1247763boloney
bolshy1444883bolshy
bonaci10310963bonaci
bond75334363bo_n_d
bonds86126843bo_nds
bone65949323bo_n_e
boned85133243bo_ned
boner75133083bo_ner
bones76446533bo_nes
bong75633413bo_n_g
bongo85720943bo_ngo
bongs87828423bo_ngs
bonk105531713bo_n_k
bonks116326463bo_nks
bonne75124713bo_nne
bonnes85621453bonnes
bonnet85524633bonnet
bonnie85314853bonnie
bonnily1236873bonnily
bonnock1545203bonnock
bonus75324323bo_nus
bonze165119353bo_nze
booby125319513bo_oby
boody115420403bo_ody
boogey124711523boogey
boogy114518323bo_ogy
boomy125421823bo_omy
boon67142173boon__
boons75031913boon_s
booty106125913bo_oty
boozy194917063bo_ozy
boric98024223boric_
born67338413born__
borne77926793born_e
borsch1336133borsch
borty105522833bo_rty
bosky145612393bo_sky
bosomy13509033bosomy
bossy105515973bo_ssy
bosun75113593bosun__
bosuns8439383bosun_s
botany1139263botany
botch126717453bo_tch
botchy16537823botchy
botfly1436093botfly
bothy136713963bo_thy
boubou1038423boubou
boucle103712783boucle
boudin9412373boudin
bouffe14438313bouffe
bough115719313bou_gh
boughs125414373boughs
bought125115633bought
bougie93613273bougie
boule74828043bou_le
boules84925973boules
boulle84614613boulle
bouncers12309353bouncers
bouncier1236033bouncier
bouncing13318773bouncing
boundary1444753boundary
bounded113613763bounded
bounden10389453bounden
bounder104215533bounder
bourg84113843bou_rg
bourgs9459993bourgs
bourn75518483bou_rn
bourne83714093bourne
bournes93615023bournes
bourns84114063bourns
bourse84414333bourse
bouse75931853bou_se
boused95322883boused
bouses84931783bouses
bout66353293bou__t
bouton8311533bouton
bouts75131313bou_ts
bowery146012113bowery
boxily1877843boxily
boxy166420733bo__xy
boy87753563bo___y
branch134014773branch
branchy17357913branchy
brandy124712063brandy
branny115111833branny
briny104719663brin_y
bronc91714343bronc_
bronco10179493bronco
broncs101611153broncs
bronzy20306713bronzy
browny144510043brown_y
brumby15385953brumby
brunet84419293brunet
brung84613913brun_g
brunt75728753brun_t
brunts85215453brunts
brushy14468263brushy
bubby115013923b_ubby
buck125129903b_u_ck
buddy124812633b_uddy
buffy165013373b_uffy
buggy124613483b_uggy
bulgy115214103b_ulgy
bulky146215573b_ulky
bully105124813b_ully
bumpy144715053b_umpy
bun56348143b_un__
buna64730723b_un_a
bunas75126573b_unas
buncos104011593b_uncos
bund75530663b_un_d
bunds85523543b_unds
bundt85824853b_undt
bung75730633b_un_g
bungs85323863b_ungs
bunk105731353b_un_k
bunko115514513b_unko
bunks115125083b_unks
bunn65023653b_un_n
bunns74718293b_unns
buns66243723b_un_s
bunt65850853b_un_t
bunts75729803b_unts
bunya103810093b_unya
buoy95921783b_u_oy
buoyancy1842673buoyancy
buppy144810073b_uppy
burly104922833b_urly
burry105221563b_urry
bury95633593b_u_ry
busby126113293b_usby
bushy135416683b_ushy
busty105621013b_usty
busy94727173b_u_sy
butch125416543b_utch
butty104020113b_utty
buy86436543b_u__y
chancy164010863chancy
chunky18468273chunky
clunky15447893clunky
cogency1547013cogency
conch124620073co_nch
conchy163710223co_nchy
coney105932883co_ney
conky145818743co_nky
cony96537833co_n_y
corny106023273corn_y
couch125320113cou_ch
council1137463council
count74932053coun_t
country12388033country
counts84618273counts
crunch13349503crunch
crunchy17324763crunchy
donsy96414683do_nsy
doubly12328963doubly
douce85518423dou_ce
doughy14499843doughy
dourly103210433dourly
downy125714553down_y
dunce86319263_dunce
dunch115316263_dunch
dungy104713643_dungy
ebony104511513ebo_n_y
enounce937573enounce
fancy134615483_fancy
flounce1235413flounce
fluency1545353fluency
flunky16408093flunky
foully1239013foully
found94917843foun_d
foundry1433913foundry
founds104814193founds
fount84727033foun_t
founts94313383founts
frounce1236153frounce
funky154315133_funky
funny114614833_funny
glunch1255353glunch
gooney106612313gooney
goony95519783goon_y
gouty95217363gou_ty
grungy11345973grungy
gunky135514113_gunky
gunny94413663_gunny
haunch14377343haunch
honey115629913ho_ney
honky156218523ho_nky
horny115619623horn_y
hound95016483houn_d
hounds104413133hounds
hourly12369623hourly
hunch136416213_hunch
hunky155417733_hunky
jaunce15367433jaunce
jaunty16388513jaunty
johnny1932193johnny
jounced17337613jounced
jounces16369853jounces
journey1734873journey
juicy1738283_juicy
junco144612203_junco
junky194513233_junky
koruny1334443korun_y
launce8469183launce
launch11368063launch
looney94712413looney
loony86918963loon_y
loudly1037783loudly
lounge75211213lounge
loury85716753lou_ry
lousy84617083lou_sy
lunacy1136843_lunacy
lunch104917243_lunch
luny77324133_lun_y
maundy12506783maundy
mincy125817413_mincy
money104826843mo_ney
mony96830003mo_n_y
moony104818273moon_y
mouch124715803mou_ch
mouldy12437413mouldy
mound83918313moun_d
mounds93915133mounds
mount74128063moun_t
mounts84115073mounts
mousey115216193mousey
mousy106716943mou_sy
mouthy14409063mouthy
munch124917103_munch
nancy105214923_nancy
nonce75719823no_nce
noun45724183noun__
nounal639813nounal
nouns56717313noun_s
once65423083_o_nce
only75319723_o_nly
ouch95724633_ou_ch
ounces83617773_ounces
outby10411533_outby
outcry1137993_outcry
paunch13369853paunch
paunchy17324443paunchy
plunky15377953plunky
pointy114913283pointy
policy133211513policy
ponce95222513po_nce
pony96434053po_n_y
porny106020193porn_y
potency1457433potency
pouch124617083pou_ch
pouchy16538663pouchy
pouffy17395883pouffy
pounced123510623pounced
pouncer113511233pouncer
pounces114113893pounces
pound84417863poun_d
pounds93714383pounds
pouty107018813pou_ty
punch125118423_punch
punchy16398523_punchy
punky144419393_punky
punny104217713_punny
punty106021613_punty
puny95526993_pun_y
raunch11358433raunch
raunchy15284313raunchy
roughy137010853roughy
round64318433roun_d
roundly1136723roundly
rounds73615613rounds
roupy106112713rou_py
runny84613483_runny
runty86119043_runty
saucy104615163sau_cy
skunky12436163skunky
sluicy1166483sluicy
sonly85718053so_nly
sonny85016103so_nny
sonsy86416373so_nsy
sound64420023soun_d
soundly1136683soundly
sounds74616183sounds
soupy106115403sou_py
source8410673source
sourly93612203sourly
spunky15427163spunky
sunny84917743_sunny
toney86027413to_ney
tony75635153to_n_y
touch106519393tou_ch
touchy145010503touchy
toughy135911073toughy
tourney1036273tourney
towny116114493town_y
trounce936823trounce
truancy1244993truancy
tunny86515033_tunny
unci65019463__unci
unco66021403__unco
uncoy104111413__uncoy
undy85015163__undy
vaunty12409063vaunty
vouch134611903vou_ch
wonky154011773wo_nky
wound94414213woun_d
wounds103811633wounds
young977743youn_g
youngs1035383youngs
zincy195413513_zincy
zounds164310173zounds

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163826.01618736.0
3Display Results3823820.1233105.7
 (SQL Overall)1786913826.27928458.5
 
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.