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

170 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
enough104575(None) 
enoughs1144621enoughs
bough115719312_bough
chough15699242chough
clough12539132clough
cough115819642_cough
dough105217382_dough
lough95118482_lough
nought104713962_nought
plough12577562plough
rough97819432_rough
slough10539232slough
sough95320462_sough
though139410762though
tough97321982_tough
trough108512022trough
unrough11105232unrough
abought1346143abought
ankush13114433ankush
avouch1434833avouch
besought1453993besought
borough1344513borough
boughs125414373_boughs
bought125115633_bought
brought13308683brought
brugh115414293_brugh
choughs16576623choughs
choush14549063choush
cloughs13517053cloughs
couch125320113_couch
coughs125514543_coughs
couth106122483_couth
crouch133910203crouch
debouch15124253debouch
doughs115912933_doughs
dought114915513_dought
doughy14499843_doughy
drought12258873drought
drouth104410103drouth
eloign7456983eloign
encage93713503encage
encash11276943encash
endash10297123endash
endue64215353endu_e
endued83910373endued
endues73813903endues
endure74014143endure
enduro7338623enduro
energy10137513energy
eng46726783en__g_
engage82812103engage
engorge945543engorge
engs56121393en__gs
engulf1038883engulf
enmesh1134893enmesh
ennui537523ennu_i
ennuis636473ennuis
ennuye973753ennuye
enoki9268873eno_ki
enokis103010273enokis
enol45823823eno__l
enolic8413353enolic
enology11239813enology
enols54718403eno_ls
enorm74415633eno_rm
enosis63816423enosis
enounce937573enounce
enow77819873eno__w
enows85115493eno_ws
enrage72715073enrage
enrich1138943enrich
ensign737523ensign
ensoul638253ensou_l
ensouls736033ensouls
ensue54013833ensu_e
ensued73610483ensued
ensues63313813ensues
ensure63416003ensure
enuf7323843en_u_f
enure53520223en_ure
enwound11134813enwound
epoch1248203epo_ch
erugo6369853e_rugo
eunuch1154363eunuch
faugh125712963_faugh
fought135112393_fought
gouge78220063_gouge
grouch12318473grouch
haugh125114053_haugh
heugh125410923_heugh
infought1543523infought
inrush936513inrush
kiaugh1442813kiaugh
knout95018263knou_t
knouts10438313knouts
laugh94414373_laugh
loughs105014773_loughs
menorah1247933menorah
mouch124715803_mouch
mouth105420293_mouth
naught104312493_naught
neigh94912383_neigh
nigh85220663_n_igh
nog46847313_no_g_
nogg65115943_no_gg
noggs75811183_noggs
nogs56534613_no_gs
noh66640643_no__h
north86018273_north
nosh76223543_no_sh
notch105613323_notch
nougat74712653_nougat
noughts11478083_noughts
noun45724183_nou_n
nouns56717313_nouns
nous46136983_nou_s
onrush935343onrush
ouch95724633__ouch
ought95221533__ought
ouph95618373__ouph
ploughs13526103ploughs
pouch124617083_pouch
pugh106619233__pugh
rebought1474393rebought
refought1564233refought
resought1254983resought
retouch1235853retouch
rouge65423443_rouge
roughs105416213_roughs
roughy137010853_roughy
routh86423073_routh
saugh95318403_saugh
scouth115011153scouth
shaugh13287433shaugh
sheugh13295883sheugh
slouch11438523slouch
sloughs11497563sloughs
sloughy14535803sloughy
snog55623633sno_g_
snogs66017493sno_gs
snout54530633snou_t
snouts64915863snouts
snouty9419953snouty
snug55218693sn_ug_
snugs64913023sn_ugs
soughs105115623_soughs
sought106315053_sought
south85223573_south
sugh86423443__sugh
tenour62610733tenou_r
tenours72610053tenours
teugh95511613_teugh
thought14639133thought
through141647513through
touch106519393_touch
toughs105414983_toughs
toughy135911073_toughy
troughs11698673troughs
ugh76520683___ugh
unbought1443763unbought
uncouth1247173uncouth
unfought1543543unfought
unsought1244233unsought
venous93713193venou_s
vouch134611903_vouch
vugh117115723__vugh
waugh125411683_waugh
wrought14276923wrought
yogh116616143_yo_gh
youth115315043_youth

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 Limit1127161705.31321215.1
3Display Results1701700.0632698.4
 (SQL Overall)1786911705.51632395.0
 
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.