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

261 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
jouncy1833620(None) 
bouncy13409071bouncy
jounce153310731jounce
bounce104014832bounce
bounty113411072bounty
county114313322county
flouncy1543672flouncy
jaunce15367432jaunce
jaunty16388512jaunty
johnny1932192johnny
jounced17337612jounced
jounces16369852jounces
journey1734872journey
juicy1738282j_uicy
junco144612202j_unco
junky194513232j_unky
loungy10476832loungy
ounce77019932_ounce
pounce105214092pounce
adunc837433adunc_
agency1237033agency
aunty85919813_aunty
boney105227313bo_ney
bonny105816623bo_nny
bony96732083bo_n_y
bounced123610553bounced
bouncer113811333bouncer
bounces113813683bounces
bouncily1544383bouncily
bound84819583boun_d
bounds94415803bounds
bousy104917843bou_sy
brunch13329353brunch
bunch125118603_bunch
bunchy16437463_bunchy
bunco94616083_bunco
bunny104715803_bunny
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
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
janty156816963j_anty
jaunced17335473jaunced
jaunces16307423jaunces
jaunt125025273jaun_t
jaunts137511883jaunts
jenny153811623j_enny
jitney16304623jitney
jock176522643jo__ck
jockey22408033jockey
jocund1633623jocun_d
jocundly2142213jocundly
joey145719333jo__ey
john145512903john__
johns15398713john_s
join116724833join__
joined144613073joined
joiner134114133joiner
joinery17366593joinery
joins125818413join_s
joint125227723join_t
jointly1735483jointly
joints133811453joints
jokey195014693jo_key
jokily20306533jokily
joky186215313jo__ky
jolly154517513jo_lly
jolty155713033jo_lty
jones125028183jo_nes
jotty155012603jo_tty
joual12311653jou_al
jouals1338923jouals
jouk156015993jou__k
jouked18568153jouked
jouks165612343jou_ks
joule124918203jou_le
joules134116823joules
jouncier1734423jouncier
jouncing18336853jouncing
journal1484963journal
journeys1843203journeys
journo13135293journo
journos14134943journos
joust125122293jou_st
jousts135011273jousts
jowly186410903jo_wly
joy137036363jo___y
joyance1944773joyance
juco134716203j_u_co
juice14311323j_uice
jumpy195712813j_umpy
jun105932063j_un__
juncos15449233j_uncos
jungly17407693j_ungly
junk155121033j_un_k
junks164815973j_unks
junta123713673j_unta
junto125114563j_unto
jury146719593j_u_ry
jutty154914643j_utty
koruny1334443korun_y
launce8469183launce
launch11368063launch
looney94712403looney
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
unbouncy1552863unbouncy
unci65019463__unci
unco66021403__unco
uncoy104111413__uncoy
undy85015163__undy
vaunty12409063vaunty
vouch134611903vou_ch
wonky154011773wo_nky
wound94414213woun_d
wounds103811633wounds
young977743youn_g
youngs1035383youngs
zincy195413513_zincy
zounds164310173zounds

Search took 6 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 Limit1127162614.92322895.8
3Display Results2612610.0932806.5
 (SQL Overall)1786912615.15634656.9
 
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.